Pauls Blog

Breakfast $23.65 Lunch $26.55 Dinner $45.60

     

Make sure to include the ADO 2.1 References  This is the command to establish a connection to the current Access database in VBA. Set conn = CurrentProject.Connection Set objRec = New ADODB.Recordset Read Only Connection: objRec1.Open strSQL, conn Write Connection:  objRec2.Open strSQL, conn, adOpenForwardOnly, adLockOptimistic

Where does excel save the personal workbook %APPDATA%\Microsoft\Excel\XLSTART\PERSONAL.XLSB How to show the developer tab in Office applications http://msdn.microsoft.com/en-us/library/bb608625.aspx