dear all,,
I just try to make script to autosave an opened excel that auto refresh every 3 hours. Every 3 hours the data will be added to excel,, cause the excel will take data from database (that the cause I need to autorefresh).
but I need to autosave it too. I use M.Office 2003. In M. Office 2003, the output of autosave just a temporary. So I just, copy the temporary, n rename it. But, I want to make it, just to make command from CMD to save my opened excel that every 3 hours will be added.
tiil now, I just make this code :
for /F "usebackq" %%A IN (`dir /O:D /B *.xls`) do (
set FI=%%A
)
ren %fi% sample.xls
del D:\db_duplicate\sample.xls
xcopy sample.xls D:\db_duplicate\