Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.vb.ole.automation,microsoft.public.excel.programming,comp.os.ms-windows.programmer.ole
|
|||
|
|||
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 |
#2
Posted to microsoft.public.vb.ole.automation,microsoft.public.excel.programming,comp.os.ms-windows.programmer.ole
|
|||
|
|||
a little help? OLE object, which version of app?
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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Drew Hershkowitz wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Wrap Text: Print Version different than Screen Version | Excel Discussion (Misc queries) | |||
Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) |