Excel VBA
 

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

Excel VBA
 

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
.

Excel VBA
 

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
.

Excel VBA
 

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
.

.

Excel VBA
 

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
.



.

Excel VBA
 

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

Excel VBA
 

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


.

Excel VBA
 

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

....


.

Excel VBA
 

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


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

....


.


.

Excel VBA
 

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

http://msdn.microsoft.com/library/de...omaddinvb6.asp

(watch out for wrapping)

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



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

....


.


.