View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Open Workbook (VBA)

It happens that Javed formulated :
The name property returns only the name of file and to open we need to
specify the path.So use Path property of File object also.


Thanks for that! I did miss that important point as I'm not a user of
FSO for getting file locations. Makes perfect sense!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc