I am trying to use a macro using ExportWithFormatting to export a Table to an excel file.
I would like the file name to be a field in another table. This field is also in a form that is open if that is preferable.
There are many threads here and elsewhere and it seems this can't be accomplished using a macro.
I do not know how to use VB code, but if someone could help I might be able to get it done that way.
The name of the table to output is "BOM Table"
The name of the file I would like to use is a field named [Serial Number] in a table name [Selected Serial Number].
Any help would be appreciated.
I would like the file name to be a field in another table. This field is also in a form that is open if that is preferable.
There are many threads here and elsewhere and it seems this can't be accomplished using a macro.
I do not know how to use VB code, but if someone could help I might be able to get it done that way.
The name of the table to output is "BOM Table"
The name of the file I would like to use is a field named [Serial Number] in a table name [Selected Serial Number].
Any help would be appreciated.