Running a Macro in 1st workbook, when a specific second workbook opens

[rossmcn1]

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 file with the same workbook name every time.

What I want to happen is upon the Workbook2.csv file opening (after the download), is to automatically run code that copies the data from the .CSV file into Workbook 1.

Is it possible?

If you need the actual code I can add it, but for simplicity I'll leave it as a question for now.

Cheers in advance for the help you can give

Ross

 

[Joe4]

You can run a macro from one workbook on another, especially if you know the name of the other one.

You can actually use the Macro Recorder to get most of the code you need. Just record yourself doing the steps manually, and then view your code, i.e.

    Windows("WorkBook2.csv").Activate
    Range("A1:A5").Copy
    Windows("WorkBook1.xlsm").Activate
    ActiveSheet.Paste