473,574 Members | 17,716 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Outlook application with VBA - converting to VB.NET

We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we can password-protect the code, but that does not give us the desired level of security

We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've seen some references on various newsgroups indicating that this will not work, and we need to use Visual Studio .NET instead. We do not have a copy of Visual Studio .NET; it's expensive and we'd rather not purchase it if we don't need it. Can someone clarifiy whether we do or do not need it

Thanks
Ernie
Nov 20 '05 #1
6 4540
what version of VB.NET do you have?

describe more this executable that your going to distribute, you should have
no problems....
"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we can
password-protect the code, but that does not give us the desired level of
security.
We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've
seen some references on various newsgroups indicating that this will not
work, and we need to use Visual Studio .NET instead. We do not have a copy
of Visual Studio .NET; it's expensive and we'd rather not purchase it if we
don't need it. Can someone clarifiy whether we do or do not need it?
Thanks,
Ernie

Nov 20 '05 #2
Ernie,
Are you staying with Outlook 2000 or can you upgrade to Outlook 2003?

Is this an in house app or do you sell it? (do you need to support multiple
versions of Outlook).

I would consider creating a properly constructed COM Add-In in VB.NET that
uses the PIA for Outlook 2003. As an Outlook 2003 Add-In will avoid the
security prompt.

For a list of articles on using Outlook from .NET see:

http://www.microeye.com/resources/res_outlookvsnet.htm

For a plethora of automating Outlook with VBA, VB6, and VBScript see:
http://www.outlookcode.com/

To avoid the Outlook security prompts its generally easiest to create a
properly constructed COM-Addin for Outlook 2003. There are other methods
available for other versions of Outlook...

See:
http://msdn.microsoft.com/library/de...scomaddins.asp

Further info can be found at:
http://www.slipstick.com/dev/ol2003problems.htm
http://www.slipstick.com/outlook/esecup/admin.htm

The links I gave have samples of creating add-ins.

Both of these are good articles to start with:
http://msdn.microsoft.com/library/de...addinvbnet.asp

http://support.microsoft.com/?kbid=302896

Also, be certain you have explicitly installed the Outlook PIAs!

Hope this helps
Jay
"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we can
password-protect the code, but that does not give us the desired level of
security.
We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've
seen some references on various newsgroups indicating that this will not
work, and we need to use Visual Studio .NET instead. We do not have a copy
of Visual Studio .NET; it's expensive and we'd rather not purchase it if we
don't need it. Can someone clarifiy whether we do or do not need it?
Thanks,
Ernie

Nov 20 '05 #3
Ernie,
Additional info, the ItemsCB is a good reference VB6 addin.

http://www.microeye.com/resources/itemsCB.htm

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

Hope this helps
Jay
"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we can
password-protect the code, but that does not give us the desired level of
security.
We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've
seen some references on various newsgroups indicating that this will not
work, and we need to use Visual Studio .NET instead. We do not have a copy
of Visual Studio .NET; it's expensive and we'd rather not purchase it if we
don't need it. Can someone clarifiy whether we do or do not need it?
Thanks,
Ernie

Nov 20 '05 #4
If you want security.
Purchase VB 6 and use VB 6 to automate Outlook.
You then compile the VB 6 code into a DLL which is referenced by the
remaining code in Outlook.
You should be able to redesign the Outlook code so a minimal amount is all
that is exposed, the rest of the code gets called in the class you created
in VB 6. And password protect the code that remains in the VBA project.

Check at www.pricegrabber.com to see who claims to still be selling VB 6.
Recently, at least www.atomicpark.com and www.vbxtras.com were still selling
the critter

--
http://www.standards.com/; See Howard Kaikow's web site.
"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we can
password-protect the code, but that does not give us the desired level of
security.
We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've
seen some references on various newsgroups indicating that this will not
work, and we need to use Visual Studio .NET instead. We do not have a copy
of Visual Studio .NET; it's expensive and we'd rather not purchase it if we
don't need it. Can someone clarifiy whether we do or do not need it?
Thanks,
Ernie

Nov 20 '05 #5
Thanks for the various replies; some additional information
- this is an in-house application; it will not be sol
- we will be using Outlook 2000 for the near future; migration to a newer version of MS-Office is some time in the future. Probably tied into the purchase of new computer systems. Any support of multiple versions will be limited to the conversion / installation period. However we don't anticipate much support being required since we probably won't be accepting very much in the way of change requests (yeah, famous last words!
- Since I have to go thru a central purchasing department to obtain software, I'm not sure that we will be able to obtain VB 6.0. I will check into that, though - that did look like the best solution for us at this particular point.

Thanks
Erni

----- Jay B. Harlow [MVP - Outlook] wrote: ----

Ernie
Are you staying with Outlook 2000 or can you upgrade to Outlook 2003

Is this an in house app or do you sell it? (do you need to support multipl
versions of Outlook)

I would consider creating a properly constructed COM Add-In in VB.NET tha
uses the PIA for Outlook 2003. As an Outlook 2003 Add-In will avoid th
security prompt

For a list of articles on using Outlook from .NET see

http://www.microeye.com/resources/res_outlookvsnet.ht

For a plethora of automating Outlook with VBA, VB6, and VBScript see
http://www.outlookcode.com

To avoid the Outlook security prompts its generally easiest to create
properly constructed COM-Addin for Outlook 2003. There are other method
available for other versions of Outlook..

See
http://msdn.microsoft.com/library/de...escomaddins.as

Further info can be found at
http://www.slipstick.com/dev/ol2003problems.ht
http://www.slipstick.com/outlook/esecup/admin.ht

The links I gave have samples of creating add-ins

Both of these are good articles to start with
http://msdn.microsoft.com/library/de...laddinvbnet.as

http://support.microsoft.com/?kbid=30289

Also, be certain you have explicitly installed the Outlook PIAs

Hope this help
Ja
"Ernie" <an*******@disc ussions.microso ft.com> wrote in messag
news:9C******** *************** ***********@mic rosoft.com..
We have an Outlook 2000 VBA application - 8 user forms, and about

thousand lines of code - that we wish to distribute. We know that we ca
password-protect the code, but that does not give us the desired level o
security
We plan to use VB.NET to create an executable file which we wil distribute to our users. We have tested this, and it works. However, I'v
seen some references on various newsgroups indicating that this will no
work, and we need to use Visual Studio .NET instead. We do not have a cop
of Visual Studio .NET; it's expensive and we'd rather not purchase it if w
don't need it. Can someone clarifiy whether we do or do not need it Thanks

Erni


Nov 20 '05 #6
Ernie,
- Since I have to go thru a central purchasing department
to obtain software, I'm not sure that we will be able
to obtain VB 6.0. Seeing as you have a license for VB.NET, you have a license to VB6.

http://msdn.microsoft.com/vbasic/pre...downgrade.aspx

It may cost you a small fee ($20 US) for media.
that did look like the best solution for us at this particular point. ?? Its easier to write a COM add-in in VB6 for Outlook, then it is in
VB.NET, however both are doable. With Outlook 2000, you have a greater
chance of getting the Security prompt from your application. Which can be
addressed by the links I gave earlier or Redemption. For information on
Redemption see the regular Outlook development groups...

Hope this helps
Jay

"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:CA******** *************** ***********@mic rosoft.com... Thanks for the various replies; some additional information:
- this is an in-house application; it will not be sold
- we will be using Outlook 2000 for the near future; migration to a newer version of MS-Office is some time in the future. Probably tied into the
purchase of new computer systems. Any support of multiple versions will be
limited to the conversion / installation period. However we don't
anticipate much support being required since we probably won't be accepting
very much in the way of change requests (yeah, famous last words!) - Since I have to go thru a central purchasing department to obtain software, I'm not sure that we will be able to obtain VB 6.0. I will check
into that, though - that did look like the best solution for us at this
particular point.
Thanks,
Ernie

----- Jay B. Harlow [MVP - Outlook] wrote: -----

Ernie,
Are you staying with Outlook 2000 or can you upgrade to Outlook 2003?

Is this an in house app or do you sell it? (do you need to support multiple versions of Outlook).

I would consider creating a properly constructed COM Add-In in VB.NET that uses the PIA for Outlook 2003. As an Outlook 2003 Add-In will avoid the security prompt.

For a list of articles on using Outlook from .NET see:

http://www.microeye.com/resources/res_outlookvsnet.htm

For a plethora of automating Outlook with VBA, VB6, and VBScript see:
http://www.outlookcode.com/

To avoid the Outlook security prompts its generally easiest to create a properly constructed COM-Addin for Outlook 2003. There are other methods available for other versions of Outlook...

See:
http://msdn.microsoft.com/library/de...scomaddins.asp
Further info can be found at:
http://www.slipstick.com/dev/ol2003problems.htm
http://www.slipstick.com/outlook/esecup/admin.htm

The links I gave have samples of creating add-ins.

Both of these are good articles to start with:
http://msdn.microsoft.com/library/de...addinvbnet.asp
http://support.microsoft.com/?kbid=302896

Also, be certain you have explicitly installed the Outlook PIAs!

Hope this helps
Jay
"Ernie" <an*******@disc ussions.microso ft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
> We have an Outlook 2000 VBA application - 8 user forms, and about a thousand lines of code - that we wish to distribute. We know that we

can password-protect the code, but that does not give us the desired level of security.
>> We plan to use VB.NET to create an executable file which we will distribute to our users. We have tested this, and it works. However, I've seen some references on various newsgroups indicating that this will not work, and we need to use Visual Studio .NET instead. We do not have a copy of Visual Studio .NET; it's expensive and we'd rather not purchase it if we don't need it. Can someone clarifiy whether we do or do not need it? >> Thanks,

> Ernie


Nov 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
19320
by: Fritz Switzer | last post by:
Can anyone provide a small snippet in C# that pulls out the Contacts in Outlook XP. I've seen a couple of examples in C++ and VB in previous newsgroup posts, but either the originals didn't work or my conversion skills are weak. And if I have to use tlbimp.exe what is the right file to use. Thanks for the help. -- Fritz
3
4980
by: deko | last post by:
When adding Outlook Appointment Items from Access, should I use: Set ol = New Outlook.Application --or-- Set ol = CreateObject("Outlook.Application") Outlook seems to crash either way. The Outlook application (and/or Calendar) may or may not be open when this sub runs.
14
1674
by: acuttitta | last post by:
Within the next six months, our office is going to be converting it's e-mail server from GroupWise over to Outlook 2003 & MS Exchange. I have been using Dimitri Furman's (google him, he's out there) GroupWise API code for years and have been quite happy with it. However, with the conversion, I'm forced to ditch it for Outlook. The I.T....
23
25453
by: Graham F French | last post by:
Hello, I can read text files into my application, but I cannot read in msg files as they seem to be in a proprietry format. Is there anyway of converting it on the fly or is there an interpretation method? Thanks
3
6036
by: John | last post by:
Hi I am trying to access outlook contacts folders and delete the contacts that do not contain a certain category value in the categories field. I have written the below code but am stuck with the error on the indicated line. Any help would be appreciated. Thanks Regards
7
3602
by: Chris Thunell | last post by:
I'm trying to loop through an exchange public folder contact list, get some information out of each item, and then put it into a vb.net datatable. I run though the code and all works fine until i get to item 250 i get a "system.invalid cast exception" and "specified cast is not valid". Once i get this error and try to go to the next record.....
3
8273
by: wizzbangca | last post by:
Hi everyone. Having problems with a utility I am writing for work. The previous IT Director thoughtfully allowed 3 (2000, xp, 2003) versions of outlook to be installed rather than 1. Now I need the utility to work for all 3 versions. A previous post suggested creating objects to detect the version of outlook, which I tried with success. ...
5
3033
by: John A. Bailo | last post by:
I have a program that I'm converting from Outlook 2000 to Outlook 2003. It basically opens Outlook and iterates through a series of items in a public folder. I was able to run this as a scheduled task overnight. But now, it seems to want to have me be logged in already or it will not log into Outlook.
4
16674
prabunewindia
by: prabunewindia | last post by:
Hello everybody, here i am going to explain, how to get mails from Outlook express database and store in our own database(local) Initially you have to add the refference Outlook library10.0 or 11.0 from add ref. If you not find that, download the dll from here and install..click here open and windows application (or ASP.NET) in Form1...
0
7820
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...
0
8258
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...
1
7835
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...
0
6486
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...
1
5635
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...
0
5325
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...
0
3759
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3777
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2255
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.