About Us

NoviceDeveloper

Dave,

It works like a champ.

Thanks,

"Dave Peterson" wrote:

I'm confused.

Did you use VBA or VB to create your addin?

If you used VBA within excel to create the procedures, then it sounds like you
understand correctly.

NoviceDeveloper wrote:

Thanks Dave,

I will try this. But let me understand it properly:

1) In my .xla file, where the VB program is, I add the code to create the
menu bar which is the part of the shell where you indicate "In a general
module..."
2) Then, in the file where I import the .xla file, I use the code to call
the create and remove menu functions which is the part of the shell where you
indicate "Under ThisWorkbook..."

Is this correct?
--
Thanks,

"Dave Peterson" wrote:

I think most would either give the users a toolbar or add icons/options to an
existing toolbar.

Here's how I create that toolbar on the fly:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

NoviceDeveloper wrote:

Hi,
How do I register or expose a function (in a Visual Basic program created
with the Excel Visual Basic editor and saved as an .xla file) so that it is
visible when I try to use the Macro manager to assign and use it as a Macro?

I created the program and it runs fine from the VBA editor--I just can't get
to it once I load it via the .xla mechanism--it doesn't show up in the
selection window.
--
Thanks,

--

Dave Peterson

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Launch Program then load file	Keyrookie	Links and Linking in Excel	1	March 1st 10 11:45 PM
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene	LunaMoon	Excel Discussion (Misc queries)	0	July 28th 08 11:03 PM
XLA will not load	[email protected]	Excel Programming	1	October 27th 04 05:46 PM
load an add-in in VBA	dibdab	Excel Programming	1	March 3rd 04 05:11 AM
merging excel program with tdc finance program	judy	Excel Programming	0	November 5th 03 08:01 PM

Menu

About Us