View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Automate without add-ins

Are you positive?

I don't speak .Net, but when I automate from MSWord or from a .VBS, all the
addins and all the stuff in XLStart are not loaded.

If I look at tools|addins, I see that they're checked. But if I check in the
VBE for all the open projects, I only see the workbooks I created/opened.



Rob Oldfield wrote:

I'm writing something in .Net that automates Excel. That's generally fine
but I have an issue with a user who has an add-in installed such that
whenever they go into Excel, it pops up a login screen. Is there a way of
replacing...

objExcel=New Excel.Application

with

objExcel=New Excel.ApplicationWithNoAddIns

I know that I could probably do something like find the registry key that
tells Excel about the addin, turn that off, run Excel, and then switch it
back on - but that seems a bit kludgy. Is there a better way?


--

Dave Peterson