Open and Save Excel File from Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I’m trying to setup the OnOpen event of a form to open, close and save (or open, save and close) an excel file. I created a simple macro with the RunApp action to open the file I want, but I don’t know how to make the macro close the excel file and choose “yes†when prompted to save the changes

Is this something that can be done with the same macro or do I have to use coding? If code is the way to go, how would the code look like

Any help is greatly appreciated
Thanks
 
Hi MacLean,

You 'll need to use VBA code. Here are some useful articles giving the
basics of controlling Excel from Access:
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476
 
Back
Top