troubleshooting Question
VB for Excel to suspend window updating while updating another workbook
asked on
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
Application.WindowState = Excel.XlWindowState.xlMini
both ways eventually flash the file on the screen.
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
Application.WindowState = Excel.XlWindowState.xlMini
both ways eventually flash the file on the screen.
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.