Compiler says "Invalid qualifier" when using Application object

This is happening in my modules.

Intellisense offers the Application (both as a property and a class it
appears), but then the compiler says the above. I'm not trying to use
Automation or anything that might confuse that I'm in excel, although maybe
I have a reference that's confusing it??

Thanks, Eric

Post the line of code that is causing the compiler error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eric" <[email protected]> wrote in message
news:[email protected]...
> This is happening in my modules.
>
> Intellisense offers the Application (both as a property and a
> class it appears), but then the compiler says the above. I'm
> not trying to use Automation or anything that might confuse
> that I'm in excel, although maybe I have a reference that's
> confusing it??
>
> Thanks, Eric
>

That's part of the problem! I can get intellisense to show it, but can't
prompt for any properties or get a line of code using it.

Thanks, Eric

"Chip Pearson" <[email protected]> wrote in message
news:%[email protected]...
> Post the line of code that is causing the compiler error.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Eric" <[email protected]> wrote in message
> news:[email protected]...
>> This is happening in my modules.
>>
>> Intellisense offers the Application (both as a property and a class it
>> appears), but then the compiler says the above. I'm not trying to use
>> Automation or anything that might confuse that I'm in excel, although
>> maybe I have a reference that's confusing it??
>>
>> Thanks, Eric
>>
>
>

I think I'm see the source of the problem, but I don't understand why yet.
It's only in an add-in in working on that I have the problem, and probably
cause there are two Application ref's in there. When I figure out why that
is I should understand it.

Thanks, Eric
"Chip Pearson" <[email protected]> wrote in message
news:%[email protected]...
> Post the line of code that is causing the compiler error.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Eric" <[email protected]> wrote in message
> news:[email protected]...
>> This is happening in my modules.
>>
>> Intellisense offers the Application (both as a property and a class it
>> appears), but then the compiler says the above. I'm not trying to use
>> Automation or anything that might confuse that I'm in excel, although
>> maybe I have a reference that's confusing it??
>>
>> Thanks, Eric
>>
>
>