Apologies for the rule 2! I fixed it.
I try once more in order to become more specific. I have a file named "credit spreads" which needs to be refreshed its week which means that I need each week to import some additional data. This file is saved on folder "economy". After that i go into bloomberg and search for credit spreads and after i find the ones that i need I export them into a new excel file named for instance "game" and saved on the folder "downloads". I don't want a code in order to open or close my files. What i need is to create a macro button based on a vba code and when i press it I want it to add the new values from the bloomberg file into the "credit spreads" file, but independent of the bloomberg file name because the name when I download it another time could be for instance "table". I want my code to be independent of the Bloomberg file name.
Bookmarks