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?
You could crate an excel addin that would hold the code and create the required report.