Solved

VBA Controle Ellements problem

Posted on 2000-04-03
5
423 Views
Last Modified: 2010-07-27
***********VBA Only*********************
How can i call upon a controle ellement
from a external library, without installing the whole VB6 Pro package.

****************************************
My problem:
I wrote a lot of macro´s, witch all had to use some date-field.
Because there are a lot "DUMB" users with itchy trigger fingers, i chose for the use of DTPicker (mscomct2.ocx)
on my computer it runs great, but when i install it on another computer i manually have to assign the library file.
And because there are a lot of roming users and i´m don´t have that mutch time to configure all the computers.

Preferably some intergrated code.
I ASK YOU for a solution!
TNX, BabyBrain
0
Comment
Question by:BabyBrain
  • 2
  • 2
5 Comments
 

Expert Comment

by:Jan_Staecker
Comment Utility
There is no strange thing behind!

You have to build up an Installer, that ports your Version of the DTPicker to the other PC.
Then the Installer tests:
- to first time install your DTPicker,
- Upgrade the existing one with yours
- or has a newer one.

Additionally it INCREMENTS the number of applications using DTPicker by one.

Szenario:
All runs fine, but one other programm is deinstalled, it DECREMENTS the numer of uses of the OCX. If the number is 0, nobody uses the OCX and the file can be deleted.

THIS IS COM. So you need to install.

With VBA used from Microsoft Office, you can use (and buy) the
- MOD (Microsoft Office Developer Toolkit - Office 2000)
- ODT (Office Developer Toolkit - Office 97)
- ADT (Access Developer Toolkit - Office 95)

Different Names but each time the same Product for the Office. There is an Installer in the Toolkit (and also the licence (*.lic-Files) to distribute the CommonDialog, CommonControls, etc..)

If you have any VB, you can also build up an installer with the Package and Deployment Assistent.

Bye Jan





0
 

Author Comment

by:BabyBrain
Comment Utility
Tried it already and it didn´t work.
That´s another problem.
0
 
LVL 2

Accepted Solution

by:
JetScootr earned 100 total points
Comment Utility
I've had similar problems, we manually hacked the Setup.lst and pointed the DLLs and OCXs to the $APP directory instead of the windows directory.   Then running the install on the user's machines appears the same as before, but the files are copied to the application's directory.  Now the DLLs are considered to be different (because of the different location), even if they're bytewise identical.
0
 

Expert Comment

by:Jan_Staecker
Comment Utility

I answer serious Questions at www.askme.com.

Here on this site I will *NEVER* answer anything again! I don't like the system!

Bye Jan
0
 

Author Comment

by:BabyBrain
Comment Utility
Here are the points.
Tnx, it worked fine, have a nice day!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now