473,770 Members | 1,980 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4796
Maybe because of different Locale ID than U.S. ?
"Illya Havsiyevych" <ga***@ukr.ne t> 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.ne t> 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.ne t> 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_redic k@Mind_NoSpam_s pring.com> wrote in message
news:3F8AAD8F.B 2D20A2B@Mind_No Spam_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.ne t> 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_redic k@Mind_NoSpam_s pring.com> wrote in message
news:3F8AAD8F.B 2D20A2B@Mind_No Spam_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.ne t> 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_redic k@Mind_NoSpam_s pring.com> wrote in message
news:3F8AE0DB.D 5F70BCB@Mind_No Spam_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_redic k@Mind_NoSpam_s pring.com> wrote in message
news:3F8AAD8F.B 2D20A2B@Mind_No Spam_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.ne t> 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
3035
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 whether it was docked or not. I added the following code to my "OnConnection" function but it fails with an error, "Run-time exception thrown : System.IO.IOException - Bad file name or number." With applicationObject.CommandBars("SampleToolbar")
6
3311
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 in VBA from my other Access applications. This works fine and I'm quite happy with it... except for one area; error handling. In most of my functions I call an error handler which
0
1923
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. This is properly done, but the events which should be triggered with the button.click method are not triggered in Word. I don't understand because it properly works in the 3 others host applications. If someone has an issue, I would be most grateful....
0
2453
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. This is properly done, but the events which should be triggered with the button.click method are not triggered in Word. I don't understand because it properly works in the 3 others host applications. If someone has an issue, I would be most grateful....
0
2254
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 (using the python interpreter). But now, I want other poeple to use it to I want to freeze it for windows using py2exe and py2exe is giving me a headache. First, I cannot seem to be able to register my addin with the resulting executable. I've...
7
2611
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 are hit in my source code. The Addin isn't being loaded. If I create a new Addin program from scratch, e.g. AddIn1, it loads up fine from Outlook. I archived my existing code, cleared out the registry and recreated a brand new Addin project with...
1
2732
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 I have only two non-trivial methods: In OnConnection I add my event handler to OnBuildProjConfigDone, and in the event handler I executed Build.Cancel. In IDE - no problem. When I execute I see that AddIn works and Build.Cancel is called but...
6
1903
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 Outlook. Now my questions are: How an when did the registering took place? Whre is the informations stored, to wich Application the Addin should be bound?
1
1513
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
2410
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 installed while AddIn is 2003 but as I need to target both 2003 and 2007 I am sticking to lowest common denominator. I installed the AddIn by running the vs 2008 generated setup.
0
9618
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9454
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10101
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10038
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8933
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7456
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6710
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2849
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.