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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tulipsfree
- Content: Threads
- Order by date
-
need a VB msgbox based on last row of querytable object (text import)
Need the msgbox to alert when the 'last non-blank' in a column is '1' (or 'true') -- immediately after (or as part of) a refresh event of a querytable object importing a .txt file. This is some code I came up with off the top of my head that, so far, doesn't work: Sub SignalAlert() Dim j, k...- tulipsfree
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
can't get adjacent formulas to fill on a 'querytables' object
Here's the code: ********************************************************** Sub Macro1() With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Prophet\data1\S\S03Q.TXT", Destination:=Range("B4")) .Name = "S03Q_2" .FieldNames = True...- tulipsfree
- Thread
- Replies: 8
- Forum: Microsoft: Office
