We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim oExcel As New Excel.Application Dim oSheet As Excel.Worksheet oExcel.Workbooks.Add() oSheet = oExcel.ActiveSheet Dim conn As New SqlConnection(My.Settings.BRDWorklsates) conn.Open() Dim qryTable As Excel.QueryTable qryTable = oSheet.QueryTables.Add(conn, oSheet.Range("A1"), "Select * from tblActiveIngrediantAnalysis") With qryTable .RefreshStyle = XlCellInsertionMode.xlInsertEntireRows .Refresh(False) End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Calculating hours worked based on dates and times from Event logs||2||24|
|Draw a value from another worksheet, not as static text but as a formula (using VBA)||2||34|
|office 2010 not starting even in safe mode||9||94|