Hi -
I am trying to write the vba code so that when a button is pressed, it will do the command of "TransferSpreadsheet" and import that spreadsheet data and replace a current existing table.
However, the file name can change each time, so I want it to prompt the file name, and open up the dialog box to allow the user to browse for the file name.
How do I do that? Can I just do that as a macro, or does it need to be vba?