Running a macro in a different Wbk

[Yeoman.jeremy]

Hi there,
I am need of a way to run the code for a different Workbook.

I have code in (example) book1.xls that a part of needs to run a macro in book2.xls

Or if there is an easier way of doing this, much help would be appreciated.
All i want the code to do, is increment a particular number on a different workbook.

I have written code to make it all work, except that instead of incrementing on Book2.xls, it just increments on Book1.xls - so i thought i could get around this by just running a macro on book2

 

[venkat1926]

see whether you can convert the Book1 macro into an addin file put in toolbar button

refer to this url

http://www.contextures.com/xltoolbar02.html