I have a macro that imports data using the TransferText Action. I want to pass the "File Name" from my VB code as a parameter. Currently having to hard code the file name in the macro, but want to pass it as a parameter.
Here is my code for running the macro.
DoCmd.RunMacro "importlead"
I want to have a field on my form that allows them to enter the filename and path and send it to the macro.
Thanks for any assistance.
Marnie
Here is my code for running the macro.
DoCmd.RunMacro "importlead"
I want to have a field on my form that allows them to enter the filename and path and send it to the macro.
Thanks for any assistance.
Marnie