yeah, but...

Until you actually say what this means:
2. Macro will manipulate the data from the file per instructions.

I don't think you'll get much help. And you may be able to record a macro when
you do what ever manipulation you need.

#1. Take a look at application.getopenfilename
You can use that to point at a file

#2. I got nothing.

#3. I don't speak the Access

#4. Post back when you get it working for one workbook and I'm sure someone
will help you with your looping.





Jac wrote:

I think it is much more complex than recording the macro and and combine them
due to the looping process.

Thanks

"Debra Dalgleish" wrote:

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



--

Dave Peterson