To get started, turn on the macro recorder, and record the steps as you
do the process manually.

This will create some code that you can modify.

You can search the Google newsgroup archives for similar questions, that
will provide additional tips and code examples.

http://groups.google.ca/advanced_gro...ugroup=*excel*

If you get stuck modifying a specific part of the code, post a question,
including the relevant code, a description of the workbook, the Excel
version you're using, and the problem you're having.

Jac wrote:
Hi,

Please help me create a macro that does the following:
1. Macro will prompt me to key in a file name from a specific folder.
2. Macro will manipulate the data from the file per instructions.
3. Macro will transfer data to an Access database and will also Prompt as to
which table to upload the data.
4. This process will go into a looping process until the folder [from #1 is
empty].

Your assistance will be greatly appreciated.

Thanks
Jaq


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html