I want to be able to select a cell in my active workbook, click a button to open another workbook in the same directory, and then pass the cell value to the input box of the macro in the other workbook and run the macro with that input value....
so far, I've got this:
The macro I want to run is call NewProject on the other workbook.Please Login or Register to view this content.
I get error that it cannot find "\ProjectCosts.xls!NewProject", Proj (I also tried without the \ at front)
Bookmarks