Hi

I want to create a macro that copies data from an Access table to an Excel
worksheet, inserting a new worksheet each week, copying the data on to it and
naming it (the worksheet) with the date the data was copied. So I would have
a series of worksheets named 1 Nov 06, 8 Nov 06, 15 Nov 06 etc. Is there a
way I can get the macro to name each new worksheet sequentially like this?

Many thanks

GLS
--
GLS