Extract from multiple .out files to one Excel worksheet

Please Login or Register  to view this content.

Then amend your Sub to receive and use the file name

Thanks, i can't test it till Monday. How do I amend my sub to receive??

Thanks

Ive highlighted the amendments made in bold (if you copy and paste then be sure to remove the [B] formatting bits!

Please Login or Register  to view this content.

I guess I need steps from the beginning to use Macro you've made, as it is not seeming to do the trick.

My problem is pretty basic-I recorded a very simple macro, (hit record, selected a cell, stop recording) then entered VBA and pasted above into the module, clicked the save button, saved the macro enabled worksheet and exited, back to blank xcel sheet. Then I click Macros and there are none to choose from to run. I seem to get this result each time.

I also am not sure what changes to make to above for my use. I don't see any formatting?? Do I need to enter a path or filename anywhere??

Have you got the two Subs in a Module of your workbook (doesnt matter if theyre in the same module or not)?

If so then putting your cursor on the Sub LoopFiles() line and clicking the Play button on the ribbon or Run from the menu will run it.

I've attached my WB.

try this, you werent actually calling your macro, Ive commented the code thats been changed.

Holy crap, thank you so much.

Can I assume that worked?

It worked!! This will save me a ton of time. Thank you!!

Just purely out of interest, maybe you could you use the old copy method from command prompt to merge all of your files together? Maybe:

Please Login or Register  to view this content.

Might be barking up the wrong tree though - not sure if would even work with .out files.

Thanks

Chriz

Yes, this works. I didn't think it did till I went into my Daily Run Files and found an 'all.out' file. I just imported into excel, everything is there. So now there are options..This is just great!