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
|