troubleshooting Question

VB for Excel to suspend window updating while updating another workbook

Avatar of wlwebb
wlwebbFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelVB Script
8 Comments1 Solution567 ViewsLast Modified:
Hello Experts.

I have an Excel workbook that opens a second workbook copies range(s) of info from the 1st workbook finds the last line of input on the 2nd workbook and pastes the values of the info to that 2nd workbook.

It is annoying to see the program open the 2nd workbook and then copy the info to it and save and close that 2nd workbook.

Is there a way in VB to open the second WB in minimized state and do the copy, paste, save and close of that 2nd WB without it flashing on the screen?

I have tried both:
    Application.ScreenUpdating = False
    Application.WindowState = Excel.XlWindowState.xlMinimized

both ways eventually flash the file on the screen.

ASKER CERTIFIED SOLUTION
Makrini

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 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 1 Answer and 8 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