a little help? OLE object, which version of app?

  • Thread starter Thread starter Drew Hershkowitz
  • Start date Start date
D

Drew Hershkowitz

I have a VB app that places an excel sheet on a form. It creates an
instance of excel automatically, which is fine. When I click into the
grid to edit, I get all the menus, etc., so I am forced to turn off
all the menus and commandbars so the user will not do anything but
edit the data.

Here's the issue: If the user already had excel open, the instance
that is grabbed for the OLE work is THAT instance, turning off the
menus for the user, etc. How can I force it to use a NEW instance of
excel? Ive tried the early vs. late binding, no luck. I cannot point
the OLE object at a particular instance of excel.

Any help would be appreciated!

Thanks,
DH
 
Drew -

When I included these lines in a macro in PowerPoint, it opened a new
Excel instance, leaving alone the instance already open.

Dim xlApp As Excel.Application
Set xlApp = CreateObject("Excel.Application")

- Jon
 
Back
Top