Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
common subroutines - add-in
Here is another article or two you might find useful:
http://msdn.microsoft.com/library/ba...n_addins97.htm http://msdn.microsoft.com/library/of...exceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications to call a macro in an addin you have to use application.Run Application.Run "Myaddin.xla!Macro1" If you create a reference from the workbook to the addin (tools=References in the VBE) you can call the Macro as if it was contained in that workbook. -- Regards, Tom Ogilvy "Kanan" wrote in message ... hi, I have 7 subroutines that are common in my 10 different workbooks. In other words, the vba code is the same in all workbooks. Is it possible to create an add-in type so that I don't have this code in each workbook? If yes, pls let me know the exact steps. I tried the add-in . But I encountered 'unknown sub error ' in my workbook where I was calling the subroutine from the add-in. thanks Kanan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
common subroutines - add-in
Hi,
thanks for your answers. I was able to create an addin and use it in my other workbooks. Now I am encountering another issue. How do I modify the code in one of my subroutine in my add-in. For some reason my changes don't get saved. Is this even possible? Or Do I need to modify my .xls version and then create new .xla everytime. thanks Kanan "Tom Ogilvy" wrote: Here is another article or two you might find useful: http://msdn.microsoft.com/library/ba...n_addins97.htm http://msdn.microsoft.com/library/of...exceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications to call a macro in an addin you have to use application.Run Application.Run "Myaddin.xla!Macro1" If you create a reference from the workbook to the addin (tools=References in the VBE) you can call the Macro as if it was contained in that workbook. -- Regards, Tom Ogilvy "Kanan" wrote in message ... hi, I have 7 subroutines that are common in my 10 different workbooks. In other words, the vba code is the same in all workbooks. Is it possible to create an add-in type so that I don't have this code in each workbook? If yes, pls let me know the exact steps. I tried the add-in . But I encountered 'unknown sub error ' in my workbook where I was calling the subroutine from the add-in. thanks Kanan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
common subroutines - add-in
Kanan,
Modify the code in the VBE, and then just save the addin from there using the disk icon button. This will overwrite the add-in. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kanan" wrote in message ... Hi, thanks for your answers. I was able to create an addin and use it in my other workbooks. Now I am encountering another issue. How do I modify the code in one of my subroutine in my add-in. For some reason my changes don't get saved. Is this even possible? Or Do I need to modify my .xls version and then create new .xla everytime. thanks Kanan "Tom Ogilvy" wrote: Here is another article or two you might find useful: http://msdn.microsoft.com/library/ba...n_addins97.htm http://msdn.microsoft.com/library/of...exceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications to call a macro in an addin you have to use application.Run Application.Run "Myaddin.xla!Macro1" If you create a reference from the workbook to the addin (tools=References in the VBE) you can call the Macro as if it was contained in that workbook. -- Regards, Tom Ogilvy "Kanan" wrote in message ... hi, I have 7 subroutines that are common in my 10 different workbooks. In other words, the vba code is the same in all workbooks. Is it possible to create an add-in type so that I don't have this code in each workbook? If yes, pls let me know the exact steps. I tried the add-in . But I encountered 'unknown sub error ' in my workbook where I was calling the subroutine from the add-in. thanks Kanan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
turn off subroutines | Excel Discussion (Misc queries) | |||
Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
Common footer but not common margins please -(Page 1 of 2) etc | Excel Discussion (Misc queries) | |||
Duplicate Subroutines | Excel Programming | |||
Run method for subroutines | Excel Programming |