View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jerm.hannley@gmail.com is offline
external usenet poster
 
Posts: 4
Default setting current directory

Hello all,

I can set the current directory using the following

myCurrentFolder = ActiveWorkbook.Path
ChDir myCurrentFolder

this works great for my 'file choser' dialog box on my local drive c:
the problem occurs for a mapped network drive... using the same line of
code and running the macro from a mapped network drive it sets my
dialog window to my documents.

does anyone know why this is the case? or any direction to solve this?

regards,
jerm