How to Pass a user input file name to an import macro

[andyswen]

I need to prompt a user for an input file name and path which I want to then pass to a routine (I have a macro already done) that imports the data into the existing application tables. I can run the macro successfully with a fixed input file name but I need to allow for a variable input file name.

Thanks in advance
Andy

 

[GDGarth]

One way to do it is to put a text box on a form, and have the user enter the name in the box. I use this to pass parameters to queries and reports all the time.

I haven't done it in a macro, but I'm guessing it works the same way - where you put the name in, just type:

forms![your form name].[your textbox name]

You could have a command button on the form to run the macro.

 

[jfgambit]

This is much better executed in a Module than a Macro. I have a sample db that opens a Common Dialog box, allows the user to select the file and then stores that in a tezxtbox, where you can use it as the path for an import, export or hyperlink file. Let me know if you want a copy by giving me an e-mail address where I can send it.



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[andyswen]

A copy would be helpful. You can forward it to andyswen@aol.com

Thanks

 

[jon92]

Could you send me a copy please

jon92@btinternet.com

thanks

 

[jfgambit]

All your answers and a link to the db is here...

Enjoy

thread702-563930

"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[dinats]

Can somebody send me a copy as well please...

dinats@yahoo.com

Thank you!

 

[jfgambit]

Dinats...

Just follow the link above...



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"