View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Handling Server Paths in code

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

Tim.


"Wayne" wrote in message
...
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