Follow File Path in cell

Hello,

I am in need of a macro that will follow a file path in cell A7, and copy all the data from a worksheet, I can do the rest.

I am automating a process where we pull from a new excel file, every morning that corresponds to the date. I have a concat function tacking the proper date code to the end of the filepath, and i just need a macro to follow that.

My initial thought was to have it open a folder "Data Reports", then search the file name i have in A7 and go into that.

Whatever the experts feel is best

Change path and such to suit.

Please Login or Register  to view this content.