File Picker

[rajwar]

Hi all,

Hope you are well and patient enough to go through this with me.

I am trying to create a multiple file picker. The code is below.

I want to open the first file of lets say 5 selected files, do some autofilter task, copy data from that file, paste it in another workbook and close it. Open second file, do some autofilter task, copy data from that file, paste it in below the first file pasted data in another workbook and close it... and File 3... and so on.

It works for one file, the code for copying pasting is not yet added. I think I can manage that. But how I return to the fileicker function after it opens the first file.

Please Login or Register  to view this content.

Many thanks,
rajwar

[Leon V (AW)]

put "PlaceMarker:" where you want the macro to return to and ask for another file and at the end of the macro before the last end if put "Goto PlaceMarker".

you could also start with a "Do While True" and end with a "Loop" and have

Please Login or Register  to view this content.