Need Macro To Close Excel Application

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

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.
 
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
 
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
 
Back
Top