Dear Sintek,
Thanks for the response. I will explain it in more detail. Imagine that I have file1 and file2 (taken from Bloomerg) both open. What I am saying is that I know how to write a macro code in order to import the new data from file 2 to file 1. However, each time the file that I download from bloomberg will have a different name imagine for instance file(3). How can I write a code that always imports the new data from the bloomerg file to file 1 independent of bloomberg file's name?