Hi

The thanks is entirely due to Jim, and i am sure he will be pleased to
know that you got it working.
Thank you for posting back to let us know that it solved the problem.

--
Regards

Roger Govier


"Quco" wrote in message
...
Roger,

It works!!! Thank you very much... this is exciting! I'm going to
learn more
about macros and visual basic.

"Roger Govier" wrote:

Hi

As Jim said at the beginning of his post, put your Path in cell A1 of
the sheet.
A1 G1\Gulf

As for where you enter the code, Right click on the sheet tab.
Choose View Code, which will open up the Visual Basic Editor.
Choose InsertModule
Copy Jim's code and paste into this module
Go back to the Excel sheet, View tabMacros dropdownViewHighlight
macro "a"Run

For more information on getting started with macros then

David McRitchie has lots of useful help on his site at
http://www.mvps.org/dmcritchie/excel/install.htm
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards

Roger Govier


"Quco" wrote in message
...
This forum/discussion is creating more questions each time I read
it.
It
seems like it's limited to computer programmers? anyway, thanks to
all
for
your inputs. My new questions a

1. What is a Macro?
2. How do I run it using Excel 2007?
3. Should I replace "FilePath" for "G:\Gulf" in that code? (I did
it,
then
save the Excel spreadsheet and open it again, but nothing hapens).
4. Where can I learn more about writing codes to use in Excel?