Application.ScreenUpdating won't compile properly 1

[ohershey]

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:

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!

 

[PHV]

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

 

[ohershey]

Beautiful. That was exactly what I needed. I'm so used to just calling it with:

Application.ScreenUpdating = False

I didn't realize that I needed to call it as:

Word.Application.ScreenUpdating = False

from MS Access. Thanks!