Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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.
|Troubleshooting a Macro for Doubleclick a Character in a Range Cell||4||13|
|How to set focus on a dynamic control||18||26|
|Set arraylist as datatable||2||10|
|Overwriting Named Ranges||13||31|