By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

VB IDE AddIn with VS VB 6.0

P: n/a
Hello

I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
Registering it, startup Access, do Load and get Type mismatch error

What it can be ?

Also was trying to create the same by using VS.Net. Is it possible ?

Thank's
illya
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Maybe because of different Locale ID than U.S. ?
"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bm**********@news.wnet.ua...
Hello

I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
Registering it, startup Access, do Load and get Type mismatch error

What it can be ?

Also was trying to create the same by using VS.Net. Is it possible ?

Thank's
illya

Nov 12 '05 #2

P: n/a
The line

Set VBInstance = Application

gives this error, But Application is Not Null and it is of VBE Object Type

illya
"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bm**********@news.wnet.ua...
Hello

I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
Registering it, startup Access, do Load and get Type mismatch error

What it can be ?

Also was trying to create the same by using VS.Net. Is it possible ?

Thank's
illya

Nov 12 '05 #3

P: n/a
TR
Are you using the add-in designer? I believe you specify whether it runs in
the VBA IDE or the VB IDE. They are similar but different. I have seen some
add-in examples that supposedly work in both environments (has some code that
determines which it is being loaded and and sets the VBInstance appropriately.
But I was not successful using it (and did not pursue it). Instead I opted for
setting to VBA, compiling the dll under one name, then setting to VB and
compiling to another name. Then (on my dev machine) unregister both, and
reregister both.
Illya Havsiyevych wrote:
The line

Set VBInstance = Application

gives this error, But Application is Not Null and it is of VBE Object Type

illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bm**********@news.wnet.ua...
Hello

I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
Registering it, startup Access, do Load and get Type mismatch error

What it can be ?

Also was trying to create the same by using VS.Net. Is it possible ?

Thank's
illya


Nov 12 '05 #4

P: n/a
Yes, using Designer.
VB IDE add in is selected
All compiled Ok
regsvr32 addin.dll - ok
get it in Access VB IDE AddIns list - Ok
Check box load - ok
Close this AddIn manager window - error.
"TR" <t_NoSpam_redick@Mind_NoSpam_spring.com> wrote in message
news:3F8AAD8F.B2D20A2B@Mind_NoSpam_spring.com...
Are you using the add-in designer? I believe you specify whether it runs in the VBA IDE or the VB IDE. They are similar but different. I have seen some add-in examples that supposedly work in both environments (has some code that determines which it is being loaded and and sets the VBInstance appropriately. But I was not successful using it (and did not pursue it). Instead I opted for setting to VBA, compiling the dll under one name, then setting to VB and
compiling to another name. Then (on my dev machine) unregister both, and
reregister both.
Illya Havsiyevych wrote:
The line

Set VBInstance = Application

gives this error, But Application is Not Null and it is of VBE Object Type
illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bm**********@news.wnet.ua...
Hello

I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
Registering it, startup Access, do Load and get Type mismatch error

What it can be ?

Also was trying to create the same by using VS.Net. Is it possible ?

Thank's
illya

Nov 12 '05 #5

P: n/a
TR
Access uses the vba ide. I have an add-in that works in both Access ide and vb
ide (code is virtually identical), but I compile them separately, changing the
setting in the Desgner object.
For access, in the Add-in Designer, for application, I select Visual Basic for
Applications IDE.
For VB, I choose Visual Basic.

You can change the designer settings by viewing the designer object.

When I create the DLL, whichever I have chosen to create, VB registers it as an
add-in in both the VBA and VB ide (at least this has been my experience).
Therefore, one or the other will give an error (depending on which was last
created). That is why I create both (using differetn names), then deregister and
reregister each separately.
Is your add-in available in the VB IDE? and works without error?

Illya Havsiyevych wrote:
Yes, using Designer.
VB IDE add in is selected
All compiled Ok
regsvr32 addin.dll - ok
get it in Access VB IDE AddIns list - Ok
Check box load - ok
Close this AddIn manager window - error.

"TR" <t_NoSpam_redick@Mind_NoSpam_spring.com> wrote in message
news:3F8AAD8F.B2D20A2B@Mind_NoSpam_spring.com...
Are you using the add-in designer? I believe you specify whether it runs

in
the VBA IDE or the VB IDE. They are similar but different. I have seen

some
add-in examples that supposedly work in both environments (has some code

that
determines which it is being loaded and and sets the VBInstance

appropriately.
But I was not successful using it (and did not pursue it). Instead I opted

for
setting to VBA, compiling the dll under one name, then setting to VB and
compiling to another name. Then (on my dev machine) unregister both, and
reregister both.
Illya Havsiyevych wrote:
The line

Set VBInstance = Application

gives this error, But Application is Not Null and it is of VBE Object Type
illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bm**********@news.wnet.ua...
> Hello
>
> I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
> Registering it, startup Access, do Load and get Type mismatch error
>
> What it can be ?
>
> Also was trying to create the same by using VS.Net. Is it possible ?
>
> Thank's
> illya
>
>


Nov 12 '05 #6

P: n/a
Hello

the problem seems not in registering
But I'll check

Thanks
illya

"TR" <t_NoSpam_redick@Mind_NoSpam_spring.com> wrote in message
news:3F8AE0DB.D5F70BCB@Mind_NoSpam_spring.com...
Access uses the vba ide. I have an add-in that works in both Access ide and vb ide (code is virtually identical), but I compile them separately, changing the setting in the Desgner object.
For access, in the Add-in Designer, for application, I select Visual Basic for Applications IDE.
For VB, I choose Visual Basic.

You can change the designer settings by viewing the designer object.

When I create the DLL, whichever I have chosen to create, VB registers it as an add-in in both the VBA and VB ide (at least this has been my experience).
Therefore, one or the other will give an error (depending on which was last created). That is why I create both (using differetn names), then deregister and reregister each separately.
Is your add-in available in the VB IDE? and works without error?

Illya Havsiyevych wrote:
Yes, using Designer.
VB IDE add in is selected
All compiled Ok
regsvr32 addin.dll - ok
get it in Access VB IDE AddIns list - Ok
Check box load - ok
Close this AddIn manager window - error.

"TR" <t_NoSpam_redick@Mind_NoSpam_spring.com> wrote in message
news:3F8AAD8F.B2D20A2B@Mind_NoSpam_spring.com...
Are you using the add-in designer? I believe you specify whether it runs
in
the VBA IDE or the VB IDE. They are similar but different. I have seen

some
add-in examples that supposedly work in both environments (has some
code that
determines which it is being loaded and and sets the VBInstance

appropriately.
But I was not successful using it (and did not pursue it). Instead I
opted for
setting to VBA, compiling the dll under one name, then setting to VB
and compiling to another name. Then (on my dev machine) unregister both, and reregister both.
Illya Havsiyevych wrote:

> The line
>
> Set VBInstance = Application
>
> gives this error, But Application is Not Null and it is of VBE Object Type
>
> illya
>
> "Illya Havsiyevych" <ga***@ukr.net> wrote in message
> news:bm**********@news.wnet.ua...
> > Hello
> >
> > I'm trying to create VB IDE AddIn by using MS VS 6.0 SP5 with VB.
> > Registering it, startup Access, do Load and get Type mismatch

error > >
> > What it can be ?
> >
> > Also was trying to create the same by using VS.Net. Is it possible ? > >
> > Thank's
> > illya
> >
> >

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.