Hi Guys,

So I'm new to excel macros and I need a macro to open a file. The filepath doesn't change but the filename does and it depends on the run time and run batch.

For example in this filename the numbers change:
ProfitAndLoss_Adj_lasqfra_21765564_Emerging-Markets---Equity_31012013

21765564 is so random that it depends upon so many things like time, batch run and so on. I have no idea how to make a formula for that. For the last one, though, that's just the date of the file and I have figured that out. is there a way to disregard 21765564 and be able to link the file in macro?

I have another problem. What code can I use to select from cell a2 up to column bn down to the last active cell (please do note the range/rows differ every week but a to bn stays the same) and append that to one tab. I have to repeat these thrice copying cell a2-bn++ using three different files