Instead of distributing a copy of imagemagik or whatever it is called, why not give everyone a copy of a macro that ftps the file to a server where you have the app, a macro there will check the directory and rotate the image and send it back. Job done. None of that is very hard either if you break ...

Just before you replied I had the brainwave to show the watchlist and see what appeared...

Funnily enough what you have mentioned is exactly the reason I was asking; I was making the cancel and x buttons have the same result.

Thanks JRL

I know it is a simple one, but I can't seem to find the answer.
When I press the x button, what output is produced ? What is the default value of that button.

Cheers guys.

I may be too late, to reply, but I think there is a simple resolution for this. Why not set excel to autosave the document to a network drive My computer - tools - map a network drive... The remote guardhouse computer could autosave the document to it's "C:"drive then Macrocheduler could copy and pa...

I'm running a macro that checks some critical processes. It is no good just checking them and saying everything was fine, the bosses want to see what it checked, and the result. Eventually written to a log (easy part) I am trying to have a dialogbox running that shows key parts of the checks, like w...

I'm sure that there is a vb command that will do this.

Something along the lines of stringreplace.

then you simply replace" " ( a space) with "" (nothing)

Cheers, if you lived in Wales, I'd buy you a beer.

me_again Spot on !!! VBstart VBend Let>mystring=sdaf^safdsfsa^ VBEval>Replace("%mystring%","^",chr(1)),newstring writeln>c:\test.txt,result,newstring I made a slight adjustment as you can see to write to file, but you have solved my little problem. Out of curiosity is chr(1)) the ascii>1 ie. chr(23...

Tried a stringreplace type of thing : readln>c:\test.arq,5,remmacro Stringreplace>remmacro,ascii>1,€,newscript writeln>c:\newtest.arq,newscript it doesn't work.... It looks like I need to get MS to run ascii>1 first. Kind of a BODMAS thing in maths do the brackets first.... Stringreplace>remma...

Wow, thanks for the replies guys, JRL the idea you have, while very simple, and I'm sure effective, would mean that I would need this application installed on all users machines, plus there is the "idiot" factor where the ascii001 file is bound to be deleted etc. There are ways around all this but i...

If I change the font of notepad I can actually see the characters as I say, it looks like SOH written in small letters diagonally down from left to right. I can view it I can copy and paste it around within notepad.... but I can't create one from scratch, and I can't get MS to write one. Thanks for ...

I'm in the early throws of creating a macro to interact with "Remedy" the companies ticketing system. I can't have direct access to the remedy database so I either have to tab from field to field entering data which is slow, (as the front end is a joke), or I can get Macro scheduler to write a simpl...

Sorry for the late reply, Yep All solved.
The OnEvent command did the trick nicely and I'll probably use it in all my STK's from now on. Thanks for your answers and interest in my little problem.

Miles

One last thing... in order to make this work perfectly, does anyone know the name for the system window that networked computers get in XP, before Task Manager. It looks like is should be called "Windows Security" but it isn't... For those of you wondering what I am talking about, it is a window tha...

JRL you have hit the nail on the head, Automation Wizard indeed. I adjusted it slightly to suit the situation I was trying to resolve : OnEvent>WINDOW_OPEN,Windows Task Manager,0,CloseTM SRT>CloseTM WindowAction>3,Windows Task Manager goto>Finish END>CloseTM Blockinput>1 Let>timer=30 Let>k=0 Repeat>...