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

    Slow VBScript to BOLD lines containing todays date in Excel

    Hi Skip, conditional formatting was not an option for me as I am using vbscript and not going anywhere near excel, thanks all the same however. I actually found a much faster way of doing it and have resolved my issue with the following code: ' set currentvalue as the latest body_date...
  2. BlueFin175

    Slow VBScript to BOLD lines containing todays date in Excel

    Hi People, I have a vbscript that sorts an Excel sheet with some 800k rows by a date column (Descending) bringing today to the top, then using findnext it cycles through each row bolding todays entire row, then it resorts and saves. Trouble is there may be up to say 30k rows with todays date...
  3. BlueFin175

    Sorting an Excel 2010 Worksheet, finding a range, Coloring, then Resorting.

    I am very new to this whole VBSCRIPT thing so please forgive me ignorance. I have several very large CSV files (400k + Rows with say 30 columns) that I presently work with using ooRexx 4.1.0 I have recently figured how to save these as xlsx Excel 2010 files using vbscript. I now need to figure...

Part and Inventory Search

Back
Top