K
Katie
Hi,
I get a report of accounts each day that I would like to
import to my DB through a macro, but I need it to show a
popup asking me to locate the file to put it in. So
basically, it needs to:
1. Create a new table for todays data
2. Pop up: "Which file would you like to import?"
3. User selects file
4. Macro copies it to table, with same columns
5. Macro names the table the filename date.
I know this is probably pretty basic, just not sure how to
do it and I'm on a time crunch. Thanks for the help...
I get a report of accounts each day that I would like to
import to my DB through a macro, but I need it to show a
popup asking me to locate the file to put it in. So
basically, it needs to:
1. Create a new table for todays data
2. Pop up: "Which file would you like to import?"
3. User selects file
4. Macro copies it to table, with same columns
5. Macro names the table the filename date.
I know this is probably pretty basic, just not sure how to
do it and I'm on a time crunch. Thanks for the help...