At work I have an API for a lot of different clients. While analyzing the data for these clients I have to switch my API on a tab many times during the day. Is there a code in VBA that I could use to switch the file I get it from?
For a little background of how I do this normally, in the data tab I click on "From Text" then I paste in the API for the client. I then select that my data has headers and depending on the file I can have my import start on line 1 or 13. The API leads to a CSV so the delimiter is a comma. If anyone has a good idea on how to switch the API file with VBA then it would be much appreciated.
If this is possible please let me know.
Bookmarks