View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz Maury Markowitz is offline
external usenet poster
 
Posts: 86
Default Opening a file with a space in the name?

This line works...

Set working = Workbooks.Open("L:\theFolder\TheEmail.xls")

this one returns a 1004 error...

Set working = Workbooks.Open("L:\theFolder\TheEmail.xls")

getting "smart" I tried...

Set working = Workbooks.Open("""L:\theFolder\The Email.xls""")

The file in question WILL have a space in the name when we receive it. Is
there some trick to opening the file when there's a space in the name?

Maury