Hi all,
I write a VBA code to automatically open an Excel file.
but the way i didt doenst work (see my code).
does someone has an idea how I can deal with this.
And another question: Now I save my file as data.xls it is also possible to save it whit the date of that day??
example data21/11/11.xls or something in that way.
thanks in advance
ps. sorry for my english not that good in writing :s
I write a VBA code to automatically open an Excel file.
but the way i didt doenst work (see my code).
does someone has an idea how I can deal with this.
And another question: Now I save my file as data.xls it is also possible to save it whit the date of that day??
example data21/11/11.xls or something in that way.
thanks in advance
ps. sorry for my english not that good in writing :s
Sheets("AlarmTop10").Select
ActiveWorkbook.SaveCopyAs "C:\TEMP\Data.xls"
Workbooks("Alarmlog.dbf").Close SaveChanges:=False
Workbooks.Open "C:\TEMP\Data.xls"
ActiveWorkbook.SaveCopyAs "C:\TEMP\Data.xls"
Workbooks("Alarmlog.dbf").Close SaveChanges:=False
Workbooks.Open "C:\TEMP\Data.xls"