prompt for function arguments?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lecoughlin@gmail.com - 25 Feb 2008 18:35 GMT

I have a macro that calls a function with 2 arguments:
Import (file path, state)

This function is importing excel files into an access database. I
have to import a file for all 50 states. Is there a way to set
something up that when the code is run, it will prompt for the file
path and state?

Thanks in advance for any help.

Reply to this Message

Jackie L - 25 Feb 2008 19:03 GMT

You can base your path and state off unbound fields on a form so that those
fields would need to be populated before running the code.

If the paths stay the same for each state, it sounds though like you might
want to make a table to store the path and state and then have the code loop
through those records which would eliminate the data entry each time.

Hope this helps,
Jackie

> I have a macro that calls a function with 2 arguments:
> Import (file path, state)
[quoted text clipped - 5 lines]
>
> Thanks in advance for any help.

Reply to this Message