Macros for exporting search results into excel?

[Mahendra1000]

Hello,

I just wanted to export the search results into excel files. I have googled about it and I found the VBA code for exporting, which didn't worked out for me.

I used Macros by referencing one of the tutorial and it looks fine. Does the usage of macros for exporting the data into excel is also the correct procedure?

I have seen lot of suggestions to VBA coding and I haven't find a single post in all forums regarding usage of macros for exporting data.

Does macros's for exporting has been newly introduced?

I just wanted to know that am I on the right track?

Thanks

[ranman256]

Yes, a macro can do it. (Tho limiting)
Your search query, qsFind, is put in the macro command, ImportExport.
The limiting part is, it uses the same file...

With a little VB code you can export to a new file every time...
STabName ="Expoert"
vFile = "c:\folder\myFile" & format(date,"yyyymmdd-hhnn") & ".xlsx"
docmd.transferspreadsheet acformat , "qsFind", vFile, sTabName