Avatar of Don Smith
Don SmithFlag for United States of America

asked on 

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?
Microsoft Excel

Avatar of undefined
Last Comment
Don Smith
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Hiding the Application will work as Rgonzo's code. However, you will need error handling to ensure that the application is restored if an error occurs, if not you will end up with a hidden instance of Excel.

You could crate an excel addin that would hold the code and create the required report.
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Blurred text
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.
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Sorry I misread, but I would consider working with an addin
Avatar of Don Smith
Don Smith
Flag of United States of America image

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.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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.
Avatar of Don Smith
Don Smith
Flag of United States of America image

ASKER

Got it working with simple window screenupdate false and window hide.
Microsoft Excel
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo