|
How to reference code located in an Add-in File
What is the correct syntax for calling a VBA subroutine or function that
exists in a code module the resides in an Excel add-in file? Does the calling syntax need to state the name of the code module where the called code is located? Thanks, Keith |
How to reference code located in an Add-in File
In article ,
says... What is the correct syntax for calling a VBA subroutine or function that exists in a code module the resides in an Excel add-in file? Does the calling syntax need to state the name of the code module where the called code is located? Thanks, Keith For a couple of examples see How to use a class (object) from outside of the VBA project in which it is declared http://support.microsoft.com/default...b;en-us;555159 Don't worry about the class module stuff. Just focus on how the function New_clsEmployee is called, especially the use of single quotes in the file name. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
How to reference code located in an Add-in File
Thank you for answering. I read the article and it was helpful; however, I'm
still having a problem. I have an add in named mapper.xla. I want to use the "'mapper.xla'!Sheet1" Worksheet_Activate subroutine to run worksheet activation code for the workbook that has the mapper.xla attachment. So far, nothing that I have tried seems to work. Any suggestions? Thanks, Keith "Tushar Mehta" wrote in message om... In article , says... What is the correct syntax for calling a VBA subroutine or function that exists in a code module the resides in an Excel add-in file? Does the calling syntax need to state the name of the code module where the called code is located? Thanks, Keith For a couple of examples see How to use a class (object) from outside of the VBA project in which it is declared http://support.microsoft.com/default...b;en-us;555159 Don't worry about the class module stuff. Just focus on how the function New_clsEmployee is called, especially the use of single quotes in the file name. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
How to reference code located in an Add-in File
You can also see Chip Pearson's site for a page on application level events
http://www.cpearson.com/excel/appevent.htm -- Regards, Tom Ogilvy "keithb" wrote in message ... Thank you for answering. I read the article and it was helpful; however, I'm still having a problem. I have an add in named mapper.xla. I want to use the "'mapper.xla'!Sheet1" Worksheet_Activate subroutine to run worksheet activation code for the workbook that has the mapper.xla attachment. So far, nothing that I have tried seems to work. Any suggestions? Thanks, Keith "Tushar Mehta" wrote in message om... In article , says... What is the correct syntax for calling a VBA subroutine or function that exists in a code module the resides in an Excel add-in file? Does the calling syntax need to state the name of the code module where the called code is located? Thanks, Keith For a couple of examples see How to use a class (object) from outside of the VBA project in which it is declared http://support.microsoft.com/default...b;en-us;555159 Don't worry about the class module stuff. Just focus on how the function New_clsEmployee is called, especially the use of single quotes in the file name. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| All times are GMT +1. The time now is 05:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com