I'm running a script from Catia that will make some setup sheets for our CNC programs for our shop. For some reason, it doesn't like some certain codes and this is where I'm stuck. I'm in the middle of trying to bring an existing excel document over to a Powerpoint slide. From various websites I have found this code:
Set objShapeOLE = objSlide.Shapes.AddOLEObject(30, 78, 660, 440, "Excel.Sheet")
This line works fine for what I'm doing (inserting a blank excel sheet into a Powerpoint slide). However, I want to bring in an existing excel file, so I would try:
Set objShapeOLE = objSlide.Shapes.AddOLEObject(30, 78, 660, 440, "C:\Test.XLS")
But all I get is a blank slide. Any ideas? From what I've seen on some various websites, there is another way to call out the variables like Left:30, Top:78, etc. but doing that errors out the script due to the colons.
Question
TwiztedCam
Hey..been a while.
I'm running a script from Catia that will make some setup sheets for our CNC programs for our shop. For some reason, it doesn't like some certain codes and this is where I'm stuck. I'm in the middle of trying to bring an existing excel document over to a Powerpoint slide. From various websites I have found this code:
Set objShapeOLE = objSlide.Shapes.AddOLEObject(30, 78, 660, 440, "Excel.Sheet")
This line works fine for what I'm doing (inserting a blank excel sheet into a Powerpoint slide). However, I want to bring in an existing excel file, so I would try:
Set objShapeOLE = objSlide.Shapes.AddOLEObject(30, 78, 660, 440, "C:\Test.XLS")
But all I get is a blank slide. Any ideas? From what I've seen on some various websites, there is another way to call out the variables like Left:30, Top:78, etc. but doing that errors out the script due to the colons.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts