Making Excel Workbook work invisibly
Tricky problem:
Excel Workbook 1 wants to open Excel Workbook 2 and to execute a function therein which reads a database, fills out his main sheet with data of various kinds, saves himself to disk and returns to Workbook 1. Workbook 2 is also used interactively with humans (at other times) for manual data input and explicit saving to file.
EW1 may call EW2 many times (from vba), and wants to show a message like "Processing Invoice 121" for each run (on EW1).
500 points up for grabs.
This works, but the screen keeps flashing blanks during EW2's execution.
How can I get the background EW2 from causing screen changes (like WB.visible = false, which I can't make work)?
Anu suggestions?
Excel Workbook 1 wants to open Excel Workbook 2 and to execute a function therein which reads a database, fills out his main sheet with data of various kinds, saves himself to disk and returns to Workbook 1. Workbook 2 is also used interactively with humans (at other times) for manual data input and explicit saving to file.
EW1 may call EW2 many times (from vba), and wants to show a message like "Processing Invoice 121" for each run (on EW1).
500 points up for grabs.
This works, but the screen keeps flashing blanks during EW2's execution.
How can I get the background EW2 from causing screen changes (like WB.visible = false, which I can't make work)?
Anu suggestions?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry I misread, but I would consider working with an addin
ASKER
Thanks for the suggestions, guys. I've run into a small complication on my end which will cause me to first test Rgonzo1971's solution after the weekend. Will report back.
I've requested that this question be closed as follows:
Accepted answer: 500 points for Rgonzo1971's comment #a41502294
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for Rgonzo1971's comment #a41502294
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Got it working with simple window screenupdate false and window hide.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
You could crate an excel addin that would hold the code and create the required report.