Building a repeated process into a macro

[jbortfeld]

Hi,

I'd appreciate any help I can get because I'm new to macro programming and am a bit over my head.

I'm recording a macro that will open up a series of excel files in a series of folders and then extract certain data from them. I have no problem recording a macro that opens the first workbook and extracts the necessary data but I'm wondering how I would edit the code to continually repeat the process for all the workbooks in a certain folder.

I don't really know VBA and am just trying to do this by using the recorder and then going into the code to do as little modifications as possible.

Any help would be greatly appreciated.

Joey

[theDude]

This will get you started at least (change highlighted code to your own references):

Please Login or Register  to view this content.

Hope this helps,
theDude