ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   save OLE Object to a file (https://www.excelbanter.com/excel-programming/438563-save-ole-object-file.html)

dan

save OLE Object to a file
 
I manage to open an OLE object using:
Me.<OLEObjectName.Verb = acOLEVerbOpen
Me.<OLEObjectName.Action = acOLEActivate

but how instead of opening can I save it to a folder - let's say C:\Temp

I tried to look for it online but did not find anything yet.
Many thanks,
Dan

dan

save OLE Object to a file
 
sorry, wrong group- reposted on access programming

"Dan" wrote:

I manage to open an OLE object using:
Me.<OLEObjectName.Verb = acOLEVerbOpen
Me.<OLEObjectName.Action = acOLEActivate

but how instead of opening can I save it to a folder - let's say C:\Temp

I tried to look for it online but did not find anything yet.
Many thanks,
Dan



All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com