[AccessD] Automation of Excel through Access Problem - SOLVED

Thanks Mark,  fully qualifing everything made it work.



>>>>> Hello
>>>>>
>>>>> Look at line 340 for example...
>>>>>
>>>>> >>> 340       Range("A1:I1").Select
>>>>>
>>>>> You may find if you use
>>>>>
>>>>>              excelApp.activesheet.range... Etc
>>>>>
>>>>> helps (and on any following lines that are not fully qualified or
nested
>>>>> in a WITH / END WITH block)
>>>>>
>>>>> Hth
>>>>>
>>>>> Mark