Can Excel global macro file Personal.xls be installed anywhere else 2

[WantsToLearn]

I know the default is the Excel exe folder. Must it be there or can it be somewhere else? If so, how do you change the associated path?

I have users that are in multiple locations and I would like to keep it on a network drive for them so it can follow them around.

Thank you!

 

[Dreamboat]

You state:
I know the default is the Excel exe folder.

I state:
Not true. Don't want to have anyone being confused. It needs to reside in the user's XLSTART folder.

You query:
Must it be there or can it be somewhere else? If so, how do you change the associated path?

I reply:
You can put any location you like under Tools-Options, General tab. Alterate Startup Folder.

You state:
I have users that are in multiple locations and I would like to keep it on a network drive for them so it can follow them around.

I state:
Good idea. Make everybody's alternate startup folder be the network location. It'll then load from BOTH the network location AND their XLSTART.

Hope it helps!

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: WordX Addin!

 

[WantsToLearn]

Hello Anne,

Thank you very much for your clear and concise answers. My apologies for my initial misunderstanding. This information will be most helpful.

Thanks again!

 

[Dreamboat]

No problem, Wants. Happy to help. Make sure you come back if you can't make things right. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: WordX Addin!

 

[WantsToLearn]

Hello Anne,

Now you got me thinking. I know the reason for the Personal.xls is so you can have Global macros independent of a given Excel file. Is there a way to link another Excel file into the Personal.xls file?

As an example, let's say we had some company specific information or formatting that was applied organization wide. It would be nice to have that separately so that it wouldn't have to be in everyone's Personal.xls. Any ideas?

Thanks!

 

[Dreamboat]

Read this, Wants. Lots of info... Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[SBendBuckeye]

Hello Anne,

Thanks for the tip. Some great stuff there but I still couldn't find what I was looking for in this case. Let's say I had a workbook named MiscFunctions.xls which was in the alternate startup directory so it is automatically opened when Excel starts. In that file was a public function named GetStandardHeading which returned a string of text with the Standard Company Name, etc.

How would I reference GetStandardHeading in MiscFunctions.xls to invoke it? Or should MiscFunctions be an xla and loaded as an add-in?

You have been very helpful and I appreciate your feedback.

 

[Dreamboat]

Put some code in that workbook that builds a menu or toolbar in the Private Sub Workbook_Open. That's the BEST and easiest way to run macros from an "always available" workbook. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX