LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Exporting embedded OLE objects to file

I have an Access database embedded in my Excel spreadsheet as an OLE
(created by going to Insert Object... Create from File). How would
I now export this embedded OLE to an independent mdb file?

The process for doing it right now is to simply click on the OLE with
the mouse and copying it to clipboard in Excel. Then, I go to Windows
Explorer and click Paste. (Windows has an internal way of streaming the
copied OLE object in the clipboard to an actual file!)

Is there any macro to simulate this? Specifically, the hard part is
pasting in Windows Explorer.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded objects(?) Brad Excel Discussion (Misc queries) 2 September 18th 09 04:45 PM
Embedded Objects JLMHoss Excel Discussion (Misc queries) 0 June 18th 08 03:56 PM
Embedded Objects Pete[_3_] Excel Discussion (Misc queries) 2 January 18th 08 05:03 PM
Embedded objects Mike25 Excel Discussion (Misc queries) 1 March 23rd 06 02:05 PM
embedded objects John[_62_] Excel Programming 0 October 29th 03 08:05 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"