Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

VBA Controle Ellements problem

Posted on 2000-04-03
5
426 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
ID: 2680579
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
ID: 2683883
Tried it already and it didn´t work.
That´s another problem.
0
 
LVL 2

Accepted Solution

by:
JetScootr earned 100 total points
ID: 2706267
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
ID: 2706677

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
ID: 2721871
Here are the points.
Tnx, it worked fine, have a nice day!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

856 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