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

I'm no expert, but it sounds like you'll get what you want
by storing them in a module in Personal.xls.
-----Original Message-----
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
.

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)

"SidBord" wrote in message
...
I'm no expert, but it sounds like you'll get what you want
by storing them in a module in Personal.xls.
-----Original Message-----
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
.

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

-----Original Message-----
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)

"SidBord" wrote in
message
...
I'm no expert, but it sounds like you'll get what you
want
by storing them in a module in Personal.xls.
-----Original Message-----
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
.



.

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

-----Original Message-----
I'm no expert, but it sounds like you'll get what you want
by storing them in a module in Personal.xls.
-----Original Message-----
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
.

.

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

"Jim" wrote in message
...

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
....

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

-----Original Message-----
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

"Jim" wrote in
message
...

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
....


.

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 wrote:
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


-----Original Message-----
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

"Jim" wrote in

message

...

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

....


.