<div>
I find the User Type not defined is the error. How do I define it?
</div>


I find the User Type not defined is the error. How do I define it?

<div>
Thanks. How do I reference it in Excel 2007?
</div>


Thanks. How do I reference it in Excel 2007?

<div>
It's in the VBE menus, not the Excel application menus.<br />
<br />
Kevin
</div>


It's in the VBE menus, not the Excel application menus.

Kevin

<div>
Is that a button? Where is Tools in Excel 2007?
</div>


Is that a button? Where is Tools in Excel 2007?

<div>
While looking at the Excel workbook, press ALT+F11 to switch to the VBE. You will then see the Tools menu.<br />
<br />
Kevin
</div>


While looking at the Excel workbook, press ALT+F11 to switch to the VBE. You will then see the Tools menu.

Kevin

<div>
<div class="content wysiwyg-content">
I am very new to VBA and need to use an event to establish a database connection. But it's throwing an error when I add in this code:<br />
<br />
Dim Myconnection As Connection<br />
&nbsp; &nbsp; Dim Myrecordset As Recordset<br />
&nbsp; &nbsp; Dim MyWorkbook As String<br />
<br />
Why? These are just variable definitions. RIght?<br />
<br />
Confused...<br />
<br />
Thanks!
</div>
</div>


I am very new to VBA and need to use an event to establish a database connection. But it's throwing an error when I add in this code:

Dim Myconnection As Connection
    Dim Myrecordset As Recordset
    Dim MyWorkbook As String

Why? These are just variable definitions. RIght?

Confused...

Thanks!

Why is this VBA failing?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.