Need Macro To Close Excel Application

[Guest]

I use "Scheduled Tasks" to open Excel and them populate the fields with an
XML file that I download daily via an FTP site. I have been able to open the
XML file and transform it to an Excel foramt that is then imported into
Access for database management. It works great!

After I run the macro to run Excel and import the XML data and save the
file, it then "closes" the file. But, I would also like to "close" the excel
application until it is needed the next day.

After I"close" the wooksheet, how can I "close" the Excel application?

Thanks in advance your your assistance.

 

[Tushar Mehta]

Application.Quit

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Thanks Tushar..but one more question. Following is the code, but I can't get
the app to close. Can you help?

Sub Auto_Open()
'
' Auto_Open and Auto_Close Macro
' Macro recorded 11/14/2004 by MarySue
'

'
Range("D2").Select
ActiveWorkbook.XmlMaps("OrderFile_Map").DataBinding.Refresh
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.Quit

End Sub

Thanks in advance for your help

 

[Tom Ogilvy]

Assume this code is in the ActiveWorkbook. If so, when you close the
workbook, the code stops running. So you need to depend on Excel to close
the workbook:

Sub Auto_Open()
'
' Auto_Open and Auto_Close Macro
' Macro recorded 11/14/2004 by MarySue
'

'
Range("D2").Select
ActiveWorkbook.XmlMaps("OrderFile_Map").DataBinding.Refresh
ActiveWorkbook.Save
Application.Quit

End Sub