Button Command to Transfer Spreadsheet

[diane802]

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?

[llkhoutx]

You need to prompt the user for the file name, then use that response in your TransferSpreadsheet command.

me.txtArgument = InputBox("Input the name of the file")
then

docmd.transferspreadsheet ...,Me.txtArgument,...

[diane802]

how can I have it though so that its not typing in the name, but instead browsing for it through a pop-up window?

[llkhoutx]

Why not use a combo box on your form instead of on a popup. If you use a popup, you'll have to store the value on the form unless you also call Transferspreadsheet from the popup. I recommend that you use a combo box on you form.

docmd.transferspreadsheet ...,Me.ComboboxName,...
or
docmd.transferspreadsheet ...,Me.textboxName,...