Handling Server Paths in code

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Hi! I have a master spreadsheet that I use to open other
spreadsheets via a toolbar. I want to be able to have the
macro open the file if it's not open and activate the
spreadsheet if it's already open. The problem is that to
open it I have to use the full pathname on a server, but
once's it's open, the path info isn't there any more, so
the activate command bombs out. Are there some ways to
handle that?

Wayne
 
What do you mean by "the path info isn't there any more" ?

Tim.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Macros to the Application Level 2
VBA in IE window 1
Keeping from declaring a direct path 3
Getting/using the File path of a spreadsheet 1
Active or current file path 9
Sheet selection on Autoclose 2
Macro to generate powerpoint slides 43
Alt codes 4

Back
Top