LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA to VB6 DLL, interface split to support Excel 2000-2003, 2007

Peter,

You should be able to use the Ribbon without having to port to a DLL


I am not sure about using the Ribbon without writing an XLAM/XML interface
for it (http://msdn.microsoft.com/en-us/library/bb410116.aspx).

You NEED to know the difference, all explained in the book. You might
consider developing the dll as a normal dll with an xla/s wrapper as step
through and debugging is a bit easier.


That's probably a good place to start (for me anyway). I guess some
examples of when to use which one would help.

I think I know what you have but for your ComAddin menus best forget about
storing your commandbar details in cells and port all to the VB dll.


All the commandbar/menubar information is in code, not on the XLA worksheet.

Other user preferences can be stored either in the registry or an ini file.


I am trying to avoid both of these as some of the information stored is
encrypted/hashed login information which I would prefer to keep hidden.

Thanks again,
Roger
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Applying 2003 User interface to Excell 2007 MH Excel Discussion (Misc queries) 3 February 24th 10 04:11 PM
Split Data 1 Column to 3 columns, Excel 2000 & 2003 jfcby[_2_] Excel Programming 2 March 17th 07 09:16 PM
Excel 2007 to Excel 2003 (Split data to sheets) BCLivell Excel Discussion (Misc queries) 2 October 27th 06 07:17 PM
Does not support automation or does not support expected interface Maverick Excel Programming 0 September 21st 06 09:31 AM
excel vba interface with outlook (office 2000) tmountjr Excel Programming 1 January 7th 04 04:01 PM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"