Locating the Personal workbook with a twist

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
Greetings,

I recently updated my excel software to 2019...long overdue...anywho, when I copied my workbook files I transferred a workbook named Personal.xlsb from a different machine running excel 2003. The personal workbook was included in the files that I transferred, but was of a different format.

I copied from a txt file written macros and loaded them into modules in the personal workbook in the VBE. My question is how to locate this file in my file system.

In the immediate window I typed "thisworkbook.path" and received a pathway, but the path used a file that is not present "appdata" how can I locate the personal workbook so that I can turn it into an icon for easy opening and closing?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
From what you said I guess the xlsb workbook is opened in excel.
Activate the workbook window, go to File -> Info
There on the right there must be a button Open File Location

If you already have the output from ?ThisWorkbook.Path simply copy the result and paste it into the address bar of File Explorer (I don't believe you are missing the AppData folder).
 

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
I found the file...in order to move the file I had to change a file system setting -> unhide files and folder. This allowed me to click on the AppData file

Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,311
Members
409,862
Latest member
lbisacca
Top