User-defined type not defined

Hi,

I am using an Excel file coded with VB. As it is a holiday weekend, I can't get in touch with the person who coded this file, so I am trying to figure this out on my own. I fill in the Excel sheet with the required data, then click on a 'Submit' button. What it's supposed to do is update the database with the Excel data, but instead it opens VB and gives me the user-defined type not defined error. I have seen this in some other posts on here, and have tried to go to Tools > References, but References is grayed out. I also have version 3 of the Soap Library on my workstation, which is what I think the compilation error is referencing. Please see attached. Thanks.
VB-Error.bmp
tatetryonAsked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Software Quality Lead EngineerCommented:
See below
vbe1.jpg
vbe2.jpg
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
In the VBE make sure you press stop then tools references ought to be enabled and retry to add the reference.

Chris
0
 
tatetryonAuthor Commented:
Where do I press stop?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
tatetryonAuthor Commented:
no comment
0
 
tatetryonAuthor Commented:
no comment
0
 
tatetryonAuthor Commented:
no comment
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.