您的个人宏工作簿在哪里? [英] Where is your personal macro workbook located?

问题描述

我正在寻找存储我的个人宏工作簿的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.

这篇关于您的个人宏工作簿在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！