I have a saved export called Export Temp that will save a database to "C:\Junk\Safety Self Inspection.xlsx". Is it possible to replace this predefined path with two entries from the following database?
Database Name:
Export File Location
Column Name:
Export Name 1
Ideally I'd like to leave these as two separate entries, but if they need to be combined so be it.
I have tried to use the VBA code to manually export using the following code, but could not figure out how to have it export is as an XLSX file that would keep the formatting.
Database Name:
Export File Location
Column Name:
Export Name 1
Ideally I'd like to leave these as two separate entries, but if they need to be combined so be it.
I have tried to use the VBA code to manually export using the following code, but could not figure out how to have it export is as an XLSX file that would keep the formatting.
Code:
DoCmd.TransferSpreadsheet acExport, 10, "Master", FPath & FName, True, , False