Please refer to our guidelines for contributing for further information. Please visit our Support page to contact us directly or visit our Test and Measurement Forum to post questions. You can download Programmer's Guides providing a description of the API functions for the relevant PicoScope or PicoLog driver from our Documentation page.
Getting started Prerequisites Microsoft Windows Picosdk-ms-excel-vba-examples is a set of Microsoft Excel Visual Basic for Applications (VBA) examples for PicoScope ® oscilloscope and PicoLog ® data logger products.Įxamples are provided for 32-bit and 64-bit version of Microsoft Excel and are grouped by driver name. Read data from record set Private Sub ReadRS()ĭebug.Print "ShipperID: " & mRS.Fields("ShipperID").Value & " CompanyName: " & mRS.Fields("CompanyName").Value & " Phone: " & mRS.Fields("Phone").ValueĬlose connection Private Sub CloseConnection()Ĭall OpenConnection("ServerName", "NORTHWND")Ĭall ExecuteCmd("INSERT INTO.
with SQL Server Authentication Private Sub OpenConnection2(pServer As String, pCatalog As String, pUser As String, pPsw As String)Ĭall mDataBase.Open("Provider=SQLOLEDB Initial Catalog=" & pCatalog & " Data Source=" & pServer & " Integrated Security=SSPI User ID=" & pUser & " Password=" & pPsw)Įxecute sql command Private Sub ExecuteCmd(sql As String)
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 kommentar(er)
