Missing Files when opening Workbook from VBA

[annandap]

Hi,
Is there any way to switch of the problem dialog box in Excel 2003 when opening a workbook that is missing format files.

To explain more I have several files that are downloaded from our intranet from web reports that are converted to Excel format, the issue is when they are downloaded they are missing the CSS files that format the page.

Is there anyway to tell excel to ignore these errors and continue loading the page rather than showing a dialog box.

Regards..

Peter.

 

[VBAjedi]

I haven't encountered this particular error, but unless it requires some specific input you should be able to supress it by putting:

Application.DislpayAlerts = False

in your code before it opens the workbook. Don't forget to set it back to true at the end of your code (or immediately after you open the file)!

VBAjedi

 

[annandap]

Hi,
Thanks for that, it solves my problem. One other question though, is there anyway to stop the file temporarily being displayed as it loads.

I am loading 4 files and as each loads it gets focus until the another file loads. I would actually like to load the pages in the background without losing focus on the original File.

Regards..

Peter.

 

[annandap]

Hi,
Found the property, can stop it by using:
Application.ScreenUpdating = False

Regards..

Peter.