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!

Register Log in
  • 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: *

  1. tulipsfree

    need a VB msgbox based on last row of querytable object (text import)

    oops -- forgot to mention is is VB6 for Excel. Any help at all is most appreciated... Thanks again, Tulip
  2. tulipsfree

    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...
  3. tulipsfree

    can't get adjacent formulas to fill on a 'querytables' object

    Good Call Geoff !!!! It's always the simple things! I'll keep this in mind going forward. Many Many thanks again Geoff (I'm going to have to start contributing $ soon!) Tulip
  4. tulipsfree

    can't get adjacent formulas to fill on a 'querytables' object

    (#$%&#$%&@$#^) --> This VB stuff is harder than it looks. I've got two 800+ pg. manuals on VBE and I can't seem to get a simple text import macro to work the way I need it to. Here's another approach (different manual): ************************ Sub ImportNewText() Dim qt As QueryTable, ws...
  5. tulipsfree

    can't get adjacent formulas to fill on a 'querytables' object

    Thank you for your time. Sounds like it does what I had hoped -- if I can just get it to work. Could it have something to do with the procedure being a macro? --It's as if changes to property settings have no bearing on this procedure... .RefreshOnFileOpen = True .TextFilePromptOnRefresh =...
  6. tulipsfree

    can't get adjacent formulas to fill on a 'querytables' object

    The right side -- no hidden columns. Let me as you though -- what exactly does it mean by 'fill'? Does it mean that it will actually 'fill' the adjacent cells with the formula from the row above it (as the text data is refreshed incrementally by row)? --or does it just tie into what needs to...
  7. tulipsfree

    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...

Part and Inventory Search

Back
Top