determine how excel was opened

  • Thread starter Thread starter Matt Williamson
  • Start date Start date
M

Matt Williamson

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
 
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.
Click to expand...

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.
 
Back
Top