Fri 13 Feb 2009, 17:24Delegate Edward said...
Edward has attended:
Excel VBA Intro Intermediate course
Ivalid Qualifier
I am using the
Application.DisplayAlerts = False
function. The code won't work. I get a Compile Error saying: Invalid Qualifier.
When I debug the code this line (Application.DisplayAlerts = false) is highlighted. So it looks like "Application" is not a valid object within the scope....
Huh?!
Mon 16 Mar 2009, 15:42Trainer Carlos said...
RE: Ivalid Qualifier
Hi Edward
Sorry for the delay.
This does sound weird. The Application.DisplayAlerts = False command is standard.
Is there any chance you could e-mail me the workbook with the code and running instructions, so I can run it and observe the error as it occurs. You may need to change any data that may be deemed secret.
Send it to
carlos@stl-training.co.uk
Reagrds
Carlos
