Hi,
I have an excel macro template. I wrote a VBscript to call upon that excel and run those macros. Each time I run the VBscript - after it ended it would leave a TMP file in the destination folder and create a cluster in the folder.
What should I do so that after I run the script, it won't leave a TMP file in the folder?
I think TMP file is a temp file. Do I need to kill off all the import data connection? or set variables to null at the end of the macro? Please advise. Thank you!
Here is my VBscript:
I have an excel macro template. I wrote a VBscript to call upon that excel and run those macros. Each time I run the VBscript - after it ended it would leave a TMP file in the destination folder and create a cluster in the folder.
What should I do so that after I run the script, it won't leave a TMP file in the folder?
I think TMP file is a temp file. Do I need to kill off all the import data connection? or set variables to null at the end of the macro? Please advise. Thank you!
Here is my VBscript:
Code:
Set objExcel = CreateObject("Excel.Application")
Set wb = objExcel.Application.Workbooks.Open("C:\Users\Desktop\Order_Macro.xlsm")
objExcel.Application.Run "'" & wb.Name & "'!createFolder"
objExcel.Application.Run "'" & wb.Name & "'!move_Files"
objExcel.Application.Run "'" & wb.Name & "'!create_Sheet"
objExcel.Application.Run "'" & wb.Name & "'!call_Import_Data"
wb.Close