Excel 2010 VBA, ActiveX DLL and Ribbon
Exploring the possibilities. I'm creating some classes in Class Modules for automating some of my routine development work (eg. create a combobox whcih is filled with data from a database via ADO). These will become ActiveX DLL via VB6. Now, in the new Ribbon, would it be possible to have a Ribbon tab from where I can launch a UserForm (from where I can select options like a wizard) just by adding the ActiveX Add In? ie. without also having to add an .xlam as well?
Can an expert point me in the right direction to learn how to do a Ribbon in Excel 2010 which will appear in Excel when the ActiveX DLL is Added In? And firing off the wizard?
Also re.2010. I got the RibbonX book by Robert Martin et al. Is the Excel 2010 a major change from 2007 > or are the 2007 Ribbon tutorials/tools still valid? (got VS2010 though newbie).
Thanks!
Can an expert point me in the right direction to learn how to do a Ribbon in Excel 2010 which will appear in Excel when the ActiveX DLL is Added In? And firing off the wizard?
Also re.2010. I got the RibbonX book by Robert Martin et al. Is the Excel 2010 a major change from 2007 > or are the 2007 Ribbon tutorials/tools still valid? (got VS2010 though newbie).
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Update.
Had a dig around the RibbonX book and also the RibbonCustomizer tool/evaluation. I can see I'm looking for a 'quick fix' for what is really a huge subject!
RibbonX book (Robert Martin et al) seems to have it covered from the ground up. So shall invest some time on it.
Thanks for the advice given above.
Had a dig around the RibbonX book and also the RibbonCustomizer tool/evaluation. I can see I'm looking for a 'quick fix' for what is really a huge subject!
RibbonX book (Robert Martin et al) seems to have it covered from the ground up. So shall invest some time on it.
Thanks for the advice given above.
Sounds like a good resource. Good luck with the project.
ASKER
The way I need this to work is, I want the link to exist in the Excel 2010 Ribbon (and the macro to be accessible) ONLY when the user has the ActiveX DLL Add In installed. Is the QAT approach a possible path to that result?
Steps:
I have a blank workbook.
I install my ActiveX DLL Add In.
I now have a clickable button on a Ribbon tab.
I click the button and a UserForm/Wizard pops up.
I fill the boxes and click OK > (I know the way from there)
(Remember, its a blank workbook up to this point)
Thanks.