macro ?

[Dgavilanes]

I created a new macro in Access that import an excel file called Master into a MS Access, it works fine.

My question is I would like to get a dialog box to open when I run the macro and be able to type the name of the new excel file to be imported into Ms Access.

the current code is TransferSpreadsheet
file named: d:/TGreen_V1/Master~1.xls

if possible please let me know

Thanks

Dennis

 

[wizcow]

Dennis

It sounds like you may want to build a pop up form, instead of a dialog box.
The form would have a textbox were you enter your file name and a button that transfers your files.

You could make a macro that opens the form, then tie the transfer button to your existing macro.
In your existing macro select view>>Conditions ( so the Coniditions column is visible) and enter something like;
=Forms![Pop-upFormName]![textboxName]

Okay, I didn't try this but maybe it will get you started on the right track.

HTH
Tom

 

[Dgavilanes]

Macro

You right Tom is a pop up frm.
I will investigate your suggestion asasp

thanks

Dennis