Export to Excel using Macro (1 Viewer)

Jayessh

Registered User.
Local time
Today, 14:32
Joined
Dec 30, 2019
Messages
36
I am using Macro to export Query result in Excel after filtering some records
But While Exporting User is getting Prompted for Path and File Name

Macro Action I'm using is OutputTo

I need this automatic
like

FileName+Date&Time OR
FileName-yymmdd

likewise

Is this Possible?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:02
Joined
Oct 29, 2018
Messages
21,357
If using a macro, you can store the result of an expression in a LocalVar first, so you can use it later with the file path argument.

Sent from phone...
 

Users who are viewing this thread

Top Bottom