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

    Excel Cell Tracker

    I needed code to track previous cell location. It tracks previous and current cell by row and column. If user selects a range of cell it captures the left upper cell address. I am using this do to the fact that excel does not have a keypress event for worksheet. Global CellTracker(1, 1) As...
  2. gtejas

    need code to iterate Excel query table properties

    True, but for the properties that are applicable it would be much less hassel to loop thru them and let the loop generate a report instead of listing them out one by one. They are in a object container somewhere and I am using a computer. But for now I just keep writting them out on the chalk...
  3. gtejas

    need code to iterate Excel query table properties

    All properties. AdjustColumnWidth, Application, BackgroundQuery, CommandText, CommandType, Connection, Creator, Destination, EditWebPage, EnableEditing, EnableRefresh, FetchedRowOverflow, FieldNames, FillAdjacentFormulas, ListObject, MaintainConnection, Name, Parameters, Parent, PostText...
  4. gtejas

    need code to iterate Excel query table properties

    Office Pro 2003 Yes I have found that there is not QueryTable.Properties. What I was hoping that someone might have a work around.
  5. gtejas

    need code to iterate Excel query table properties

    Looking for help with the following: Sub ListQueryTableProperties() Dim ws As Worksheet, P As propterty Dim wsQry As QueryTable Set ws = Worksheets("Sheet4") Set wsQry = ws.QueryTables(1) For Each P In wsQry.Properties Debug.Print P.Name; Tab; P.Value...

Part and Inventory Search

Back
Top