What I'm trying to do is alter the save path from XL to a Window's folder in VBA so my co-workers don't have to search for the job folders each and everytime they want to save some results. Thansk ahead of time.
Set Rec = New ADODB.Recordset
Rec.Open ("SELECT JN from Projects Where JN ='" & Job & "';")
It does not like Rec.Open and I cannot find what exactly will allow me to open the Table and Get the chart data.
Yang101
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.