Save embedded excel spreadsheet in access to excel file 
Author Message
 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.


Thu, 06 Mar 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Save Excel spreadsheet from Access

2. Use VB to save Excel Spreadsheet as Tab Delimited File

3. Saving Excel file to Excel file

4. Convert Excel or Access spreadsheet to INI file format

5. Convert Excel or Access spreadsheet to INI file format

6. read excel file in access 2000 lire fichier excel dans access 2000

7. Saving an Excel file without using Excel

8. Saving an Excel file without using Excel

9. need help: Open Excel, run macro, save file, close Excel

10. problem with access coding accessing an excel spreadsheet

11. Open Excel Spreadsheet, Save, Close

12. saving email info into excel spreadsheet

 

 
Powered by phpBB® Forum Software