asked on

Open a workbook for processing in the background (Excel 2000)

Is there a way to open a workbook using VBA's Open method (or other) without it being activated?

I'm opening, processing and closing about 40 workbooks into a flat text file, but each open is jerky - even with Application.ScreenUpdating = False.

I would rather open the workbook into the background (somehow) and process it without the user seeing everything going on in the background.

Howler_Fish

Try using the Application.Windowstate = xlMinimized
I have found in the past that it offers better performance than Application.ScreenUpdating toggling. When you are finished just set the windowstate = xlNormal.

Hope this helps,

HF

Noono

ASKER

Hi Howler_Fish,

Unfortunately I want to show the user the progress of the operation using a progress bar. I agree ScreenUpdating toggling is a bit of a nuisance and sometimes troublesome, but I do want to keep the main worksheet maximized.

Let me know if I've misinterpreted your answer

Noono

cri

Why not using the Open _Statement_ (VBA) ? Write Open in a module, put cursor on it and press F1, select the VBA variety.

Noono

ASKER

I'm using the Open_Statement_(VBA) to open the text files for output - works nice.

I'm using "Workbooks.Open WorkbookFullPath, ReadOnly:=True" where the WorkbookFullPath is the full path to the workbook I want to open.

It seems that this method always activates the workbook once it is open. If possible, I'd love a way to open a workbook as read-only, but not activated so the user doesn't even see the workbook opened into Excel... :)

I wonder is there an overloaded method somewhere out there?

ASKER CERTIFIED SOLUTION

Noono

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cri

What has to be done with the text files ? Perhaps it can be done directly by a string operation.

Brian Mulder

This question has been classified as abandoned. I will make a recommendation to the moderators on its resolution in the next round. I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
EE Cleanup Volunteer

dbase118

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ \ Points Refunded
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

dbase118
EE Cleanup Volunteer