Hi,
I was wondering whether you can run a macro in workbook 1 upon the event of another workbook (2) opening.
For example I click a button to open a webpage withing Workbook 1, I manually manipulate which data on the webpage I want to download, and upon the download it always opens a .CSV...