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
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
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.

@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.

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
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies