N NiceCalifGuy Oct 7, 2003 #1 Is there VBA that will open am embedded Excel file. Can it then save this Excel file to the desktop?
S Shyam Pillai Oct 7, 2003 #2 You can open up the embedded excel object in an excel instance with the following line of code. ActiveWindow.Selection.ShapeRange(1).OLEFormat.DoVerb 2 From there on you can grab a reference to that open object and save it. -- Regards Shyam Pillai Handout Wizard http://www.mvps.org/skp/how/
You can open up the embedded excel object in an excel instance with the following line of code. ActiveWindow.Selection.ShapeRange(1).OLEFormat.DoVerb 2 From there on you can grab a reference to that open object and save it. -- Regards Shyam Pillai Handout Wizard http://www.mvps.org/skp/how/
N NiceCalifGuy Oct 8, 2003 #3 Thanks..that code works great to open it. Now how do I grab a reference to this open object then save it to the desktop.
Thanks..that code works great to open it. Now how do I grab a reference to this open object then save it to the desktop.
