Hello,
Currently i have created an Excel file and it is constantly updating the data. So i need to save the file automatically without constantly prompting me whether i want to overwrite the file or not.. Pls help.
The command i currently used is
"workbooks("c:\temp.xls").save"