Excel VBA

[Jim]

Help!

Can someone please tell me how to get add-ins into the
Excel VB editing environment?

I know how to get them into VB and how to get them into
Excel itself, but can't work out how to get them into the
macro writing VB environment.

Thank you,

Jim

 

[SidBord]

I'm no expert, but it sounds like you'll get what you want
by storing them in a module in Personal.xls.

 

[Bob Phillips]

Jim,

Your question is not clear. An add-in is just a normal Excel workbook, but
saved as an addin (xla) rather than a workbook (xls). So just set it up as a
normal workbook, but save it as an add-in, then install it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jim]

Thank you for the tip but I'm afraid I'm still at a loss.

Does anyone know how to get add-ins in here? The usual VB
add-ins do not appear but surely there must be a way to
get them in???

Jim

 

[Jim]

OK. Thank you Bob. I will try and clarify.

I'm opening an Excel file. Then I go into the Macro-Edit
environment. In this environment (very similar to VB) I go
to Add in Manager and find no add-ins listed.

My question is, how to I get them in there? If it was VB
then I know what to do and where to register them. If it
was just an Add-in in Excel I also know what to do. This
appears a little more tricky....

Jim

 

[Toby Erkson]

Yeah Bob, that was confusing...

Jim, change the file name extension of the Add-in file from "filename.xla" to
"filename.xls" where "filename" is the name of the add-in file. Now when you
load the file it will appear as a normal workbook and you can play around with
the stuff in it. When done, save it as .xla file extension. This is what I
believe Bob was saying and from what I remember about add-ins. Bob, please
correct me if I'm mistaken.
--
Toby Erkson
Oregon, USA

Thank you for the tip but I'm afraid I'm still at a loss.

Does anyone know how to get add-ins in here? The usual VB
add-ins do not appear but surely there must be a way to
get them in???

Jim

....

 

[Jim]

Thank you for your comments Toby. I'm not after an Excel
Add-in as such.

I'm opening an Excel file. Then I go into the Macro-Edit
environment. In this environment (very similar to VB) I go
to Add in Manager and find no add-ins listed. I have full
VB on the same machine whose add-in manager lists many add-
ins that don't appear in this Office version of VB.

My question is, how to I get them in there? If it was VB
then I know what to do and where to register them. If it
was just an Add-in in Excel I also know what to do. This
appears a little more tricky.... presumably I have to
register them somewhere but where?

Jim

 

[Steve Garman]

If you're looking to install any old VB add-in into Excel's VBE (the
Macro-Edit environment you describe), I don't believe they're compatible.

Some VB add-ins, ( MZ-Tools springs to mind ) come with a version to use
with VBA

 

[Jim]

Hi Steve,

Thank you for that - it certainly would explain why I
can't seem to register any to work there.

Do you know how I could get my own source code add-ins
there? I've written a few add-ins and wanted them to
appear in that environment too.

Many thanks,

Jim

 

[Steve Garman]

I don,t I'm afraid but you might get some clues on one of the links from:

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

(watch out for wrapping)