您的个人宏工作簿在哪里?

本文介绍了您的个人宏工作簿在哪里?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在寻找存储我的个人宏工作簿的Excel文件.有谁知道该文件在Windows 7计算机上的位置?

I'm looking for the Excel file where my personal macro workbook is stored. Does anyone know where that file might be on a Windows 7 computer?

推荐答案

实际上，我找到了答案.您可以使用下面的代码找到文件PERSONAL.XLSB.

Actually, I found the answer. You can find the file PERSONAL.XLSB by using the code below.

Sub Find_Personal_Macro_Workbook() Dim path As String path = Application.StartupPath MsgBox path End Sub

需要在文件浏览器中选择隐藏的项目，以查看其位置.

Hidden items will need to be selected in your file explorer to see where this is.

希望这对需要查找此文件的人有所帮助.

Hope this helps anyone who needs to find this file.