Hi have created an excel form for the business to use. When used they will be
saved to a folder. I am after a macro that will open all the forms and
extract the fields (each form will go into one row on the new spreadsheet)
into one spreadsheet. From that I will conduct my analysis.

Can someone assist? Thanks in advance.
--
..

Thanks for your help, I will give it a go.
--
..


"CLR" wrote:

This sort of thing is very dependent on the specific Path and files you're
going after. You can put the program and the formfiles in one directory and
get them fairly easy, but if you use different directorys and paths, and MIS
should change something, your macros would be dead in the water..........try
using the macro recorder, and setting up a new workbook and then going and
getting a couple of files and copying the info to where you want it and then
close each formfile in turn before opening another.........then look at the
macro you've recorded and some things should become evident as to how to
just type in more info to expand the macro.....if you run into trouble, post
back here and someone will help.

Vaya con Dios,
Chuck, CABGx3


"LucB" wrote in message
...
Hi have created an excel form for the business to use. When used they will
be
saved to a folder. I am after a macro that will open all the forms and
extract the fields (each form will go into one row on the new spreadsheet)
into one spreadsheet. From that I will conduct my analysis.

Can someone assist? Thanks in advance.
--
.

This sort of thing is very dependent on the specific Path and files you're
going after. You can put the program and the formfiles in one directory and
get them fairly easy, but if you use different directorys and paths, and MIS
should change something, your macros would be dead in the water..........try
using the macro recorder, and setting up a new workbook and then going and
getting a couple of files and copying the info to where you want it and then
close each formfile in turn before opening another.........then look at the
macro you've recorded and some things should become evident as to how to
just type in more info to expand the macro.....if you run into trouble, post
back here and someone will help.

Vaya con Dios,
Chuck, CABGx3


"LucB" wrote in message
...
Hi have created an excel form for the business to use. When used they will
be
saved to a folder. I am after a macro that will open all the forms and
extract the fields (each form will go into one row on the new spreadsheet)
into one spreadsheet. From that I will conduct my analysis.

Can someone assist? Thanks in advance.
--
.