Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Add-Ins

Posted by Rob Jackson on October 02, 2001 7:02 AM
Help!

My problem is I have various reports scattered on various drive around a network. In order to make it easy for people to access them I wanted to create a menu as a toolbar so people can select the correct one and it will be opened. I tried it by creating a menu then hyperlinking the options to the various reports. This was not successful. I then tried writing an add-in with various sub's to open each report. However I am having difficulty linking it to the menu. I feel I have missed the point. Can anyone explain if how addins work. I know how to switch them on and off but how do you call procedures within them. Are they simply Sub's or am I wrong. How do you link them to toolbars.

Thanks in advance.

Rob


Re: Add-Ins

Posted by Ryan on October 02, 2001 12:05 PM

Rob,

I found a good article on MSDN (believe it or not). I had the same questions as you and it really helped me understand better.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcel9/html/xlcraddns.asp

This may help you out.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.