CODEWITHSUNDEEP
excelvba
Felipe
Felipe

Reputation: 163

Personal Macro Workbook has gone missing (AGAIN)!

I don´t understand why, but it´s the second or third time I've lost my Personal Workbook with all my macro copies. The only different thing that I've done was editing a macro but, when excel was closing, I haven't saved the changes. Next time I've opened excel, surprise, surprise, no Personal Workbook! Has anyone had the same problem? Does anyone know why it happens? I have already searched in (I believe so) all possible folders where It could be stored.

Thanks!

Upvotes: 3

Views: 49507

Answers (5)

lennywatson
lennywatson

Reputation: 11

Mine went missing completely and was not in the xlstart folder. I finally discovered it was because I'm on a work server, files are all network storage based, and I had just changed my network password. I think the mis-match caused my links to personal files to be temporarily broken. I logged out completely, and back in, and everything was back where it should be.

In short: I tried turning it off and turning it back on again.

Upvotes: 1

Bernard McMurray
Bernard McMurray

Reputation: 11

Using Microsoft office 365. Lost Excel and Word Macros during last update. Had an Excel File that I had copied to my laptop (Windows 10) which had not been updated. Brought it up on my desktop. Was able to see modules but no content. Was unable to remove modules. Uninstalled Office 365. After reinstall, was able to see and use macros from that file. Word macro not retrieved. Hope it helps someone.

Upvotes: 1

Pierre
Pierre

Reputation: 71

The folder where the personal macros are saved can be found by using the command:

?Application.StartupPath (without "" sign) in VBA.

Open VBA (ALT+F11) and enter the command in the field on the bottom.

Hope this helped

Upvotes: 7

Donald.M
Donald.M

Reputation: 96

For those using MacOS / OSX (El Capitan) with Excel 2016 I located my copy of Personal Macro Workbook.xlsb, which I had previously unhidden in Excel, then closed, in the following location:

~/Library/Containers/com.microsoft.Excel/Data/Application Support/User/Personal Macro Workbook.xlsb

Please note that I used multiple search functions within OSX which did not return this file in the search results for some reason.

Upvotes: 0

Alec David Whitworth
Alec David Whitworth

Reputation: 81

the file can be found for 2007/2010 users in :

C:\Users\User ID\AppData\Roaming\Microsoft\Excel\XLSTART

or somewhere similar for others.

Hope this helps

Upvotes: 8

Related Questions