New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
So basically I'm looking for anything that has a 5% change, and I also need to look for any that didn't have data on today's column. So in this case, it would be WHERE 1/2/2013 = '' but how can I chose this column/header when the value is constantly going to change?
objConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & dSource & ";" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited(,)"";Persist Security Info=False" objConn.Open SqlQry = "SELECT * FROM " & dfile & " " & _ "WHERE ([% Change] >= 5 OR [% Change] <= -5) " Rcdset.Open SqlQry, objConn For i = 0 To Rcdset.Fields.Count - 1 data_ws.Cells(1, i + 1).Value = Rcdset.Fields(i).Name Next i data_ws.Cells(2, 1).CopyFromRecordset Rcdset
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.