Alot of Flashes changing windows

macropod · #7 07-31-2018, 02:36 PM

Quote:

Originally Posted by Ken Leidner

So I must still be doing something wrong. I expect its the outdoc.Activate and the orginialdoc.Activate statements, but I don't understand how to tell the code which document to look in or output the information into without them.

As shown in the code I posted, you refer to the documents by the variables assigned to them (i.e. Doc1, Doc2). So, instead of statements like:
orginialdoc.Activate
you would reference the same document via:

Code:

With orginialdoc
…
End With

You still have a lot of unnecessary Select activity going on, too... And you don't need to keep inserting:
Application.ScreenUpdating = False
Once is enough. Moreover, once you've got the code working, you can set the Visible property of any document you open to False, further reducing the scope for flickering.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Windows 10 – Changing the Office 2007 Product Key.	ansentry	Office	2	12-07-2015 07:41 PM
Convert Ofc 2000/Windows XP OS docs to Windows 7 OS which has NO Ofc Version Loaded	mylittleturbott	Office	2	03-17-2014 03:18 PM
Problem typing alot of text into a middle column	noelr	Word Tables	3	10-02-2013 02:19 PM
Outlook requests password afeter changing windows password	pask	Outlook	5	03-16-2012 08:43 AM
screen flashes black when writing	docsobeck	PowerPoint	0	02-01-2010 11:09 AM