|
Home > Archive > MS Access database support > April 2006 > Save OLE Excel object to file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Save OLE Excel object to file
|
|
|
| I have a single Excel workbook stored as an OLE object in an Access
table. I am trying to figure out how to save this object as an .xls
file, open it, modify it, and resave it. I know how I can modify it
once it has been saved, but how do I retrieve and save this object
programmatically from Access?
| |
| Stephen Lebans 2006-04-06, 8:29 pm |
| Do you want to resave it back to the OLE field? Then simply Activate the
object and use the exposed automation Excel interface.
If you want to save the Spreadsheet to disk then you have two choices:
Activate the object and use the exposed automation Excel interface to force
a SaveAs to disk
Use the OLE extractor tool on my site to save the object to disk.
http://www.lebans.com/oletodisk.htm
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Rocco" <r_cataldo@hotmail.com> wrote in message
news:1144304687.305096.251240@t31g2000cwb.googlegroups.com...
>I have a single Excel workbook stored as an OLE object in an Access
> table. I am trying to figure out how to save this object as an .xls
> file, open it, modify it, and resave it. I know how I can modify it
> once it has been saved, but how do I retrieve and save this object
> programmatically from Access?
>
|
|
|
|
|