Thanks Dawn,
I was actually able to close it with my application object like so....
xlsApp.Application.Quit
"Crosier, Dawn" <[EMAIL PROTECTED]> wrote:
"Crosier, Dawn" <[EMAIL PROTECTED]> wrote:
Lonnie -
I am not positive on exactly how to run a macro in Excel from Access,
but here is how to do it with Word. So perhaps you can translate the
Word commands to Excel.
Inside of Access, I have
appWord.Application.Run("myMacroName")
I hope that helps.
Dawn Crosier
Application Specialist
Microsoft MVP
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Lonnie Johnson
Sent: Tuesday, June 21, 2005 8:25 AM
To: AccessDevelopers
Subject: [AccessDevelopers] Run Excel Macro From Access
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 <http://www.prodev.us/>
Please zip all files prior to uploading to Files section.
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]
