Batch processing via VBA?

I have HUNDREDS of files that I need to perform the SAME repeating tasks on... is there any way to automate/batch process via VBA?

For example...

PROMPT user to select files (multiple files, as large as batch will allow)

Then FOR EACH file in selection...
1. OPEN FILE
2. Do some stuff (I already have the code working)
3. SAVE FILE (I have this part working as well)

Right now I have all the parts working each individually, but I have open each file and run each VBA macro manually.
Is there any way to batch process these files, so I can select and walk away?

???

Please Login or Register  to view this content.

Ah, I see what's happening, it's just opening another workbook, I need to IMPORT the data from the .obj file into an existing workbook. This is way more complicated than I thought.

I apologize.

I now realize that I have oversimplified things and not explained my situation nearly adequately.
I will try to better explain the exact process I am trying to automate. Even if I have to make
a quick YouTube video to do it. Would that be acceptable?

All is not in vain, though, because I'm sure the code you provided will end up being used, I just have to figure out exactly WHERE to put it.

I REALLY appreciate your help.

In the sample code above, I would recommend declaring wb as Workbook.