troubleshooting Question

Making Excel Workbook work invisibly

Avatar of Don Smith
Don SmithFlag for United States of America asked on
Microsoft Excel
7 Comments2 Solutions126 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros