Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Delete row after finding cell.
UNTESTED Another Option would be to add each line you wish to delete to a range then zap the range at the same time.... Dim MyRange As Range Dim AnyRangeFound As Boolean AnyRangeFound = False For r = 1 To 6500 If Len(Cells(r, 8)) = "FAIL" Then Exit For ' gets out...- shager
- Post #4
- Forum: Microsoft: Office
-
How Do I Call the ODBC Administrator with Excel VBA
I used to use this Excel VBA code to open the ODBC Administrator ConnectionId = SQLOpen("", ThisWorkbook.Sheets("CNString").Range("A1"), 2) My problem is that SQLOpen is part of XLODBC which is getting old. The things I read suggest using something within ADO but... -
Display ODBC Adminstrator With Excel VBA
I used to use XLODBC's SQLOpen to cause the ODBC Adminstrator window to open. Everything I read tells me to use ADO. I need VBA code that opens the ODBC Adminstrator so I can build the Connect String.- shager
- Thread
- Replies: 0
- Forum: Microsoft: Office
