Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

User-defined type not defined

Posted on 2009-04-10
6
Medium Priority
?
244 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:tatetryon
  • 4
  • 2
6 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24118830
In the VBE make sure you press stop then tools references ought to be enabled and retry to add the reference.

Chris
0
 

Author Comment

by:tatetryon
ID: 24121756
Where do I press stop?
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 750 total points
ID: 24121895
See below
vbe1.jpg
vbe2.jpg
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:tatetryon
ID: 24306760
no comment
0
 

Author Comment

by:tatetryon
ID: 24306761
no comment
0
 

Author Comment

by:tatetryon
ID: 24306766
no comment
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month14 days, 17 hours left to enroll

577 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