Home

Two versions of Personal Macro Workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-393313%22%20slang%3D%22en-US%22%3ETwo%20versions%20of%20Personal%20Macro%20Workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393313%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20run%20a%20macro%2C%20my%20worksheet%20correctly%20pulls%20the%20code%20from%20my%20PERSONAL%20file%3B%20however%2C%20I%20have%20two%20copies%20of%20PERSONAL%2C%20and%20I%20want%20my%20worksheet%20to%20pull%20the%20code%20from%20the%20one%20that%20resides%20in%20user%5Cusername%5Cappdata%5Croaming%5Cmicrosoft%5Cexcel%5CXLSTART%20rather%20than%20my%20Dropbox%20copy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20direct%20Excel%20to%20point%20to%20the%20correct%20version%20of%20PERSONAL%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394448%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20versions%20of%20Personal%20Macro%20Workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394448%22%20slang%3D%22en-US%22%3EHow%20precisely%20are%20you%20trying%20to%20run%20that%20macro%3F%20If%20a%20button%20somewhere%2C%20then%20that%20button%20probably%20points%20to%20the%20wrong%20file%20and%20you%20need%20to%20reassign%20the%20macro%20to%20the%20button.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394027%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20versions%20of%20Personal%20Macro%20Workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BI'm%20trying%20to%20force%20Excel%20to%20look%20at%20the%20PERSONAL%20file%20that's%20in%20my%20User%20account%20rather%20than%20using%20the%20one%20in%20my%20Dropbox%20account.%26nbsp%3B%20I%20changed%20the%20name%20of%20the%20version%20in%20Dropbox%2C%20and%20then%20try%20to%20run%20a%20Macro.%26nbsp%3B%20Excel%20told%20me%20it%20couldn't%20find%20the%20file%20located%20in%20my%20Dropbox%2C%20and%20asked%20if%20I%20renamed%20it.%26nbsp%3B%20The%20fact%20that%20Excel%20told%20it%20couldn't%20find%20the%20file%20in%20Dropbox%20tells%20me%20something%20is%20directing%20Excel%20to%20look%20in%20Dropbox%20for%20the%20PERSONAL%20file.%26nbsp%3B%20I'm%20just%20trying%20to%20redirect%20Excel%20to%20look%20for%20PERSONAL%20in%20the%20usual%20storage%20location%20under%20my%20User%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393604%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20versions%20of%20Personal%20Macro%20Workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393604%22%20slang%3D%22en-US%22%3ESince%20Excel%20is%20only%20capable%20of%20opening%20one%20file%20with%20that%20name%20in%20a%20session%20I%20would%20suggest%20to%20rename%20either%20of%20the%20personal.xlsb%20files%2C%20namely%20the%20one%20that%20Excel%20does%20NOT%20automatically%20open%20on%20starting.%3C%2FLINGO-BODY%3E
Highlighted
ricksmallman
New Contributor

When I run a macro, my worksheet correctly pulls the code from my PERSONAL file; however, I have two copies of PERSONAL, and I want my worksheet to pull the code from the one that resides in user\username\appdata\roaming\microsoft\excel\XLSTART rather than my Dropbox copy.

 

How can I direct Excel to point to the correct version of PERSONAL?

3 Replies
Highlighted
Since Excel is only capable of opening one file with that name in a session I would suggest to rename either of the personal.xlsb files, namely the one that Excel does NOT automatically open on starting.
Highlighted

@Jan Karel Pieterse   I'm trying to force Excel to look at the PERSONAL file that's in my User account rather than using the one in my Dropbox account.  I changed the name of the version in Dropbox, and then try to run a Macro.  Excel told me it couldn't find the file located in my Dropbox, and asked if I renamed it.  The fact that Excel told it couldn't find the file in Dropbox tells me something is directing Excel to look in Dropbox for the PERSONAL file.  I'm just trying to redirect Excel to look for PERSONAL in the usual storage location under my User name.

Highlighted
How precisely are you trying to run that macro? If a button somewhere, then that button probably points to the wrong file and you need to reassign the macro to the button.
Related Conversations
Sharepoint for my Teams?
DrewB37 in Microsoft Teams on
4 Replies
Workbook change log info
Dean Gross in Azure Sentinel on
1 Replies
Excel Table Size in Macro
WayneEK in Excel on
6 Replies
Macro issue with email connectivity
unhappyuser in Excel on
21 Replies