Solved

VBA Controle Ellements problem

Posted on 2000-04-03
5
427 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
[X]
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
  • 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

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…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

756 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