Save embedded excel spreadsheet in access to excel file
Save embedded excel spreadsheet in access to excel file
Author
Message
KenF #1 / 1
Save embedded excel spreadsheet in access to excel file
I am trying to save an excel spreadsheet embedded as an OLE object in an access form as an excel file. I can save it manually but I want to be able to save it using VB code so that I can make numerous copies in different locations and I am also interested in trying to modify the spreadsheet using DAO but can not seem to find how to get a link between Excel DAO and the OLE object that the spreadsheet is saved as. I want to do all of this using VB code (not manually) Any help would be appreaciated.