Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Application.ScreenUpdating won't compile properly 1

Status
Not open for further replies.

ohershey

MIS
Apr 12, 2007
4
US
A common issue I seem to encounter quite often in VBA is that a method or property will not show in the object browser and/or won't compile. I often find that, after flailing around a bit, turning on the correct reference library makes the problem go away. Is there a resource somewhere that helps determine what reference library contains a given method?

Specifically, my CURRENT issue is that when I attempt to use the following code:
Code:
Application.ScreenUpdating = False
(which HAS worked in the past) I get: "Compile Error: Method or Data Member Not found"

I'd be grateful for any suggestions!
 
ScreenUpdating is a property of the Excel.Application or the Word.Application objects.
In which application container is your current VBA ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Beautiful. That was exactly what I needed. I'm so used to just calling it with:
Code:
Application.ScreenUpdating = False
I didn't realize that I needed to call it as:
Code:
Word.Application.ScreenUpdating = False
from MS Access. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top