Invalid Qualifier to a Valid Qualifier (Application)

Hi All,

This is puzzling me:

Please Login or Register  to view this content.

The code above yields me this error >>> Compile Error: Invalid Qualifier

Please Login or Register  to view this content.

If I changed it to the one above, I'm getting this >>> Run-time error '91': Object variable or With block variable not set


I tried restarting excel (closing all workbooks and opening one back) then rerun. I am still getting the same error.

How do you think this is so?

Thanks a lot!

Originally Posted by adyteo

for the second code, you need to Set oApp to the Excel.Application

Please Login or Register  to view this content.

I've tested it --- works! Thanks a lot!