Export to EXCEL with Date and Time Stamp

[fenhow]

Hi,

Is there a way to create a macro that runs a query, exports the data into an excel spreadsheet into a specific folder with a fixed name but with the date and time the report was created automatically?

Thanks.

Fen How

 

[Ziggy1]

did you figure this out? I have some code for this, I'll post it tomorrow ( have to copy from my work laptop)