VBA code to open embedded Excel file

  • Thread starter Thread starter NiceCalifGuy
  • Start date Start date
N

NiceCalifGuy

Is there VBA that will open am embedded Excel file. Can it then save this Excel
file to the desktop?
 
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/
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excell 2021 0
Embedding Excel charts in PowerPoint 1
How to remove Embedded fonts in MS PowerPoint 2003? 1
refresh data in embedded excel objects 1
Excel Embedded Excel swap data when opened 0
Microsoft Graph vs Embedded Excel Chart 4
Updating Links in Embedded Excel Objects 5

Back
Top