![]() with Windows Authentication Private Sub OpenConnection(pServer As String, pCatalog As String)Ĭall mDataBase.Open("Provider=SQLOLEDB Initial Catalog=" & pCatalog & " Data Source=" & pServer & " Integrated Security=SSPI")ī. ![]() Microsoft ActiveX Data Objects Recordset 2.8 Libraryĭeclare variables Private mDataBase As New ADODB.ConnectionĬreate connection a. Microsoft ActiveX Data Objects 2.8 Library Use Worksheet object and not Sheet object.Methods for Finding the Last Used Row or Column in a Worksheet.Loop through all Sheets in Active Workbook.Creating a drop-down menu in the Active Worksheet with a Combo Box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |