Prev: Help with Subtotal Function
Next: Form check box
From: Matt Williamson on 29 Mar 2010 16:09
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


From: Peter T on 30 Mar 2010 08:39
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" <iH8Spam(a)spamsux.org> wrote in message
news:uZ3iCv3zKHA.4384(a)TK2MSFTNGP06.phx.gbl...
> 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
>


From: Matt Williamson on 30 Mar 2010 10:51
> 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.


 | 
Pages: 1
Prev: Help with Subtotal Function
Next: Form check box