Vb6 Missing Microsoft Dts Package Object Library

However I do not have Microsoft DTSPackage Object Library in my Visual Basic's reference. Visual Basic 6 and Earlier. How to install MICROSOFT DTSObject Library.

I have a old VB 6.0 application written by someone else. When i compile the application, it throws error on every line of code where VBA reference is required so fro e.g. it throws an error in the following lines:

As soon as I prefix it with VBA.Left$, the error goes away. I was looking at the list of project References and saw only one missing reference called 'Microsoft DTS run time 1.0'. Where can I get this reference from and how can I add this in VB application. Also, is there any way, I can add VBA reference to VB application. I am running this VB application on XP machine.

I tried to connect Microsoft Access 2013 with Visual Basic 6. Microsoft Access file extension use 2002-2003 file extension as a.mdb. But Microsoft DAO 3.6 object library missing in Visual Basic 6. Jan 3, 2007 - Package Public goPackage As DTS.Package2 Private Sub Main(). Reflection ' For Missing.Value and. Microsoft DTS Custom Tasks Object Library. Remember, VBA or the code behind Excel is the same as VB6 code.

any help will be appreciated.

Microsoft Word Object Library

AnjaliAnjali

2 Answers

Object

Then you should install Microsoft DTS runtime:

Microsoft Excel Object Library

How to: Install Support for Data Transformation Services Packages:

After, add the VBA reference (if is missing)

Giorgio BrausiGiorgio Brausi

If you look at your list of Available References, you should see one for Visual Basic For Applications. Make sure this is checked and you will be good to go.

If there is more than one reference for VBA, select the one for msvbvm60.dll.

Brian M StaffordBrian M Stafford

Not the answer you're looking for? Browse other questions tagged vb6 or ask your own question.

Posted on  by  admin