View Single Post
  #1   Report Post  
Posted to microsoft.public.vb.ole.automation,microsoft.public.excel.programming,comp.os.ms-windows.programmer.ole
Drew Hershkowitz Drew Hershkowitz is offline
external usenet poster
 
Posts: 1
Default a little help? OLE object, which version of app?

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