im creating an Add-in, however i need to call a sub that is stored in another workbook, im running excel 2000 and im not sure i can do this with this version but ive tried something i read that says projectname.modulename.procedurename
however my modules are only numbered and it says that projectname is not the name of the file just the code name of the project which by default is vbaproject
but its not working for me, i can only access procedures from within the same workbook...any help please thanks!
however my modules are only numbered and it says that projectname is not the name of the file just the code name of the project which by default is vbaproject
but its not working for me, i can only access procedures from within the same workbook...any help please thanks!