473,385 Members | 2,044 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

VB IDE AddIn with VS VB 6.0

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
6 4780
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Jaime Rios | last post by:
Hi, I created a COM AddIn for Word that performs the functions that it needs to, but I needed to add the ability for the toolbar created by the COM AddIn to remember it's last position and...
6
by: jchao123 | last post by:
Dear All, I have an MDB file (Access 2000/XP) which contains generic routines I use in various apps (eg, API calls, File access classes etc). I have compiled into an MDE file which I reference...
0
by: maitrepoy | last post by:
Hello I have to create a small addin which works on Powerpoint, Word, Outlook, and Excel on Office 2000, XP, and 2003. This addin consists in adding 2 new Buttons in the "File" Menu of office....
0
by: maitrepoy | last post by:
hello I have to create a small addin which works on Powerpoint, Word, Outlook, and Excel on Office 2000, XP, and 2003. This addin consists in adding 2 new Buttons in the "File" Menu of office....
0
by: guilligan.geo | last post by:
Hello, I'm trying to create an addin for Outlook 2002 using the one provided in the demo of win32com as a starting point. I've been able to do my addin and test it if I go the "standard" way...
7
by: Joseph Geretz | last post by:
I've been working on an Addin for Outlook in C#. It hasn't been long now, just a couple of days. Suddenly though, running my project in Debug launches Outlook as specified, but no breakpoints...
1
by: AlexZh | last post by:
Hi, I'd like to stop command line build by one project build failed. To do that I've created simple AddIn (see code below), that works fine for IDE and does not work for command line. In the AddIn...
6
by: Christof Nordiek | last post by:
Hi, I created an Addin Project with the Addin-Project-Wizzard in VS2005. I added some code from a Knowledge Base How To und built the project. It worked, and the Addin got registered with...
1
by: Rainer Queck | last post by:
Hello NG, I moved my AddIn Project from one machine to a other. This AddIn is a AddIn for Visual Studio 2005.
1
by: John | last post by:
Hi I have a simple Outlook 2003 AddIn created using Outlook 2003 AddIn template in vs 2008. The full code is given below at the end. I got warnings on Interop assemblies as I have Office 2007...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.