I am trying to get the table field names as the cell names, I thought this was possible, but all I get is the file names as the first row of data.
Dim FolderPath As String
FolderPath = "C:\Access\Meter Readings for " & CurrentMonth (Doesn't need to be there, if it is, will overwrite it.)
DoCmd.OutputTo ObjectType:=acOutputTable, ObjectName:="PropertyTB", OutputFormat:=acFormatXLS, OutputFile:=FolderPath (Tried this, doesn't seem to work very well.)
DoCmd.TransferSpreadsheet acExport, , "PropertyTB", FolderPath (This works but doesn't alter the cell titles (still A B C etc), puts table field names as first line.)
DoCmd.TransferSpreadsheet acExport, , "PropertyTB", FolderPath, True (Same as above)
MsgBox "Done, transfered PropertyTB to Meter Readings for " & CurrentMonth
Any help would be appreciated, thanks Roy