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?
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?