Excell Macros

G

GLS

I have set up a macro to automate the refreshing of reports based on pivot
tables linked to Access queries. How can I:

1. Get the date to show the last time the macro was run?

2. Part of the macro involves deleting a worksheet and replacing it with
current data - how can I suppress the message that asks me to confirm I want
to delete the worksheet?

Thanks in advance.

GLS
 
Top