Cannot read file error when running Macro

[karen1573]

Hi there

I have a macro of which there's a part which opens another workbook. However the macro stops and reports "Run-time error '1004' Unable to read file.

When I open that workbook manually, however, Excel will read it fine.

Any ideas? The path to the workbook is definitely correct.

 

[RoryA]

Hi,
How are you opening the file in code, and what format is the file in?

 

[karen1573]

Hi,
The code looks like this:
Workbooks.Open Filename:= _
"\\netappa\PUBLIC\Daily Telemarketing\Platform Analysts\Chesterfield\Absence\Absence_MTD.xls"

It's just a normal .xls workbook.

 

[karen1573]

PS. The macro also opens another workbook with the exact same code, and the workbook it opens is exactly the same as the problem one, but with different data. That one opens without problems.

 

[RoryA]

If you open the file manually, save and close it, does the code work then, as a matter of interest?

 

[karen1573]

...Yes. It does.



What could cause that?

 

[RoryA]

How is the workbook created? By a server application?
You might try adding the CorruptLoad argument to your Open statement:

Workbooks.Open Filename:= _
"\\netappa\PUBLIC\Daily Telemarketing\Platform Analysts\Chesterfield\Absence\Absence_MTD.xls", CorruptLoad:=xlRepairFile

to see if that helps.

 

[karen1573]

Yes, it's exported as .xls format by our business information server (which is running Business Objects XI).

Tried the corruptLoad statement, but no luck

 

[RoryA]

You might try and see if you can find out what version of Excel it's supposed to export to.

 

[karen1573]

Thanks, I'll speak to one of the BI analysts.