I have an Access module that opens a workbook and plots some numbers in predetermined cells.
I created a macro in the excel workbook that closes the excel file.
How do I call the macro from my Access code after I am done plotting my numbers so the excel file can close?
If someone has a better way to close the entire file, I am open to that.
I was using xlsApp.ActiveWorkbook.Close, but this only closed the workbook and left the application window for excel open.
Thanks in advance.
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
http://groups.yahoo.com/group/AccessDevelopers/
[EMAIL PROTECTED]
