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 Mike Lewis 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: mwvR
  • Order by date
  1. mwvR

    Problem with PSP9 Batch Process

    Hi I'm having a problem with trying to run a batch process to change some .pcx (Zsoft Paintbrush) files to 256 colour TIFF files. I'm using PSP 9.01 and when trying to select the .pcx files from a directory, they don't appear in the "Files to Process" box. The files can be opened into PSP as...
  2. mwvR

    Automating Script for lots of files

    Sorry for this post - just found the BATCH options in PSP9. Apologies...
  3. mwvR

    Automating Script for lots of files

    I'm after any help please with Python scripting advice. I've recorded my first script in PSP9 and have immediately hit a problem. The script is intended to open a .tif file, reduce the image size, and then to save as a .gif. The problem is that there are 255 files that I need to convert, and...
  4. mwvR

    CLEANing up some imported text

    Geoff Tried both still no joy. Not to worry, and thanks for taking the time to have a look. Malachi
  5. mwvR

    CLEANing up some imported text

    Geoff The code is in a SUB though the error message does say "That function is not valid". I separated out the single line to a separate SUB, ran it, and still receive the error message. Sub findandReplaceCHR12() Columns(1).Replace What:=Chr(12), Replacement:="&quot...
  6. mwvR

    CLEANing up some imported text

    Geoff/Mike Thanks both for your responses. In regards to Find&Replace, I used the exact code: Columns(1).Replace What:=Chr(12), Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False ...but get Run-Time 1004 "Function not Valid". Because the main...
  7. mwvR

    CLEANing up some imported text

    Thanks Mike Using your code on a file (54000 odd rows including blank rows) took around 22 seconds compared to 1m 20 with my code (both with Screenupdating to false). A definite improvement! Any thoughts on why: Columns(1).Replace What:=Chr(12), Replacement:="" ...does not work...
  8. mwvR

    CLEANing up some imported text

    I've got some unprintable characters when importing a text report generated from a call handling system. I've got some code to clean using an Excel worksheet function: 'lots of gaps between lines... cRows = Range("A65536").End(xlUp).Row + 1 Range("B1").Select Do...

Part and Inventory Search

Back
Top