Results 1 to 9 of 9

Thread: VBA Syntax in VB application Throwing error

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2017
    Posts
    5

    VBA Syntax in VB application Throwing error

    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 for e.g. it throws an error in the following lines:


    Code:
    Left$, Chr, Trim$, format
    As soon as I prefix it with VBA.Left$, the error goes away. There are tons of keyword through out the application and I don't want to prefix all of them with VBA. Am I missing any reference? If so, then what is the name of the that reference. I was looking at the list of project References and saw only two missing references called "Microsoft DTS run time 1.0" and Microsoft CDO for NTS 1.2 Library. 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. Below is the image of the list of references in my project:

    Name:  2017-07-18_15-27-37.gif
Views: 504
Size:  5.7 KB



    any help will be greatly appreciated. I am using windows XP Virtual machine
    Last edited by Anjali66; Jul 18th, 2017 at 08:54 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width