opening up files rapidly

[elmasguapo]

Hello. If I'm using code to open up files. What's the best way to speed how quickly they open?

I tried this, but it's after the files open: Application.Calculation = xlManual, so I'm not sure it makes it any faster.

Any advice?

[jason.b75]

Try something like

Please Login or Register  to view this content.

File size can be a contributing factor to the time taken to open, as can file location.
Shared files on networks tend to be noticeably slower to open than a locally saved copy of the same file.

edit:

A couple of things to note with the code suggested.

If the workbook that you're using the code to open uses a Workbook_Open procedure, then disabling events will prevent that from running.
If you're opening the workbook in a new instance of excel, then you would need to reference that instance instead of Application.

[elmasguapo]

Thanks. I'll take a look at this and get back.

[elmasguapo]

Added it into my code...Wasn't much quicker (file size is probably the biggest factor), but I'll use it with some of my other code. Thanks!!

[jason.b75]

Do you actually need to open the other file, or can you work with it closed?