Hello Everyone,
I would like to raise the following question regarding copying data from workbooks. In general I know the way to write a VBA code in order to copy data from one workbook to another when I know the name of the "source workbook".
However, I am downloading data from Bloomberg on a weekly basis for a project which means that each week i have to copy and paste the new data from the bloomberg workbook to the workbook that I am working on. So in each week I have around 10-15 new data. However, it could be that the name of the workbook from where I get the data is not the same every time. Is it possible to create a VBA code that always imports data from a workbook independent of its name?
Thanks in advance!
Bookmarks