View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_30_] Robert[_30_] is offline
external usenet poster
 
Posts: 44
Default Open file in VBA

Hello,

When I walk through the following statement I get a run time error 1004
that says that the particular file couls not be found.

I used the following statement:

sFilename = Dir("H:\Risk_Management\Special_Review\Upload_file s\*.xls")
Workbooks.Open Filename:=sFilename

Do I forgot something?

Thanks for your assistance!!

Rgds,
Robert