This is very simple, but I haven't found the answer.
I have some rather complicated reports showing the business performance in nice graphs and top-10 tables. All this is based on embedded SQL/ODBC, and a huge macro usere press in order to update. It works perfectly.
On the front page I want to show when it was last updated, i.e. when was the macro last run, AND the workbook saved as a result. Like
"Data was last updated dd/mm/yyyy at hh:mm"
I can easily put a line in the macro that saves the workbook as the last thing.
I can't use the header function in excel, as it is very meagre compared to word, which actually is rather strange.
How do I do that?.
I have some rather complicated reports showing the business performance in nice graphs and top-10 tables. All this is based on embedded SQL/ODBC, and a huge macro usere press in order to update. It works perfectly.
On the front page I want to show when it was last updated, i.e. when was the macro last run, AND the workbook saved as a result. Like
"Data was last updated dd/mm/yyyy at hh:mm"
I can easily put a line in the macro that saves the workbook as the last thing.
I can't use the header function in excel, as it is very meagre compared to word, which actually is rather strange.
How do I do that?.
