Run an Add-in from another workbook

[TheCman81]

Hi All,

Thanks in advance.

Excel 2007

I'm looking for a macro to run the same Add-In on various different workbooks. Add-In name is "HRwsBTH"

I have about 20+ workbooks that I need to open and manually refresh my Add-In and it's very time consuming.

So what I would like to achieve with the macro is the following:

1. Open a file
2. Run the Add-In
3. Save the file
4. Close the workbook

I need these steps repeated for each workbook

Thanks

Colin

 

[TheCman81]

Thanks, however it only opens the first file path in column A, I've checked all the paths and they are all correct

 

[TheCman81]

Please ignore me! I had a button assigned to a different macro lol

It works perfectly. Thanks for your time wigi

 

[wigi]

You're welcome.