Is there any way via code to determine how Excel was opened? I want to run a
startup macro but only if Excel is opened via automation. Specifically, I'm
writing to an excel sheet from SQL server using OPENROWSET and I want to
clear the previous data first.

TIA

Matt

Not directly, though you might be able to infer if the instance was
automated if normally you'd expect a personal.xls and one or more installed
addins to be loaded. If not present as expected would likely mean it was
originally automated (though not necessarily an longer).

The 'specific' details you gave does not give any useful information as to
why you want to know.

Regards,
Peter T

"Matt Williamson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there any way via code to determine how Excel was opened? I want to run
> a startup macro but only if Excel is opened via automation. Specifically,
> I'm writing to an excel sheet from SQL server using OPENROWSET and I want
> to clear the previous data first.
>
> TIA
>
> Matt
>

> Not directly, though you might be able to infer if the instance was
> automated if normally you'd expect a personal.xls and one or more
> installed addins to be loaded. If not present as expected would likely
> mean it was originally automated (though not necessarily an longer).
>
> The 'specific' details you gave does not give any useful information as to
> why you want to know.
>

>> Is there any way via code to determine how Excel was opened? I want to
>> run a startup macro but only if Excel is opened via automation.
>> Specifically, I'm writing to an excel sheet from SQL server using
>> OPENROWSET and I want to clear the previous data first.
>>
>> TIA
>>
>> Matt

I have to re-think this. OPENROWSET doesn't instantiate an instance of Excel
so I doubt any opening code would run. I'll just make a blank template and
create a copy to dump the results into.