The VB Zone Discussion Board
Re(1): Drawing Shapes in Embedded OLE Excel Spreadsheet
Posted on 6/22/2004 at 04:25:12 PM by KevinWilson
I ran into the same error. However, if I've got a copy of Excel running in the background BEFORE I RUN MY PROJECT, it works fine. I wonder if there's a hook into the Excel appliation itself to perform this action? Very odd stuff. :/
NOTE: The following code works regardless of if Excel is running or not:
MsgBox oleDiagram.object.ActiveSheet.Shapes.Count
It will return 0 with no problem. This leads me to believe the problem is in the "AddShape" method of the "Shapes" collection object.
Do you have anything against running a copy of MS Excel in the background of this computer to enable this process to work?
Kevin
Replies:
There have been no replies.
You must register before you can post on this board. You can register here.
Post a reply:
Click Here to view the "old"messageboard
MAIN |
DOWNLOADS |
SAMPLE CODE |
STEP BY STEP |
DISCUSSION BOARD |
LINKS |
AUTHOR
E-MAIL
|