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...
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...
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:=""...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.