View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RandyDtg1 RandyDtg1 is offline
external usenet poster
 
Posts: 11
Default How set file open path to filepath of file opened with Explorer ?

I frequently open Excel files from Windows Explorer. Then I need other files
that are in that files directory. What VBA command will set file open path ?

I could not get application.defaultfilepath = .... to work, if that is the
right command to use. I am using File open event, I also add the file to the
recents list.

Using Excel 2000.

Thanks.