Via macro or VBA we can specify the file name with the location for the query or report export. I am exporting via macro but now the query or report picked up as the default name where the user can change while saving it.
Question: in macro how to specify the export file name without specifying the file path? save location will be chosen by the user each time. however, would like to have a custom filename rather than "qryExport" or "rptExport".
Question: in macro how to specify the export file name without specifying the file path? save location will be chosen by the user each time. however, would like to have a custom filename rather than "qryExport" or "rptExport".