Search found 438 matches

by adroege
Tue Jul 05, 2011 5:11 pm
Forum: Technical / Scripting
Topic: Email fonts and signature
Replies: 2
Views: 3594

Using the smtp send command ( or other method ) can you change the default font in the email? This requires sending HTML formatted email and not just plain text. Haven't tried this with smtpsend. You would have to code the HTML email first for it to send. Another option is to script Outlook using V...
by adroege
Wed Jun 29, 2011 2:52 pm
Forum: Beginners
Topic: read line ?
Replies: 5
Views: 6877

how can i use this formula MidStr>13233,2,2,somevalue for lots of number.because ý have 20000 line..and i have to write to another txt Let>k=1 Label>start ReadLn>c:\number.txt,k,line If>line=##EOF##,finish If>line=,finish MidStr>line,2,2,outvalue WriteLn>c:\new_number.txt,result,%outvalue% Let>k=k...
by adroege
Wed Jun 29, 2011 2:26 pm
Forum: Beginners
Topic: read line ?
Replies: 5
Views: 6877

i want to separete second and third number to another txt i mean

13425 --> give me 34

Code: Select all

MidStr>13425,2,2,somevalue
Message>somevalue
by adroege
Wed Jun 29, 2011 2:07 pm
Forum: Technical / Scripting
Topic: Outlook 2010 Email Issue
Replies: 2
Views: 4630

Have you tried the SMTPSendMail command? Doing it with the built-in Macro Scheduler command would mean that you are no longer dependent upon Outlook even being installed , let alone running on your computer. SMTPSendMail SMTPSendMail>recipients,server,from_address,from_name,subject,body,attachments ...
by adroege
Wed Jun 29, 2011 1:20 pm
Forum: Beginners
Topic: read line ?
Replies: 5
Views: 6877

From the Help file ------------------------ MidStr>string,start,length,result Returns a substring of specified length from a given position in a string. result is a variable in which to store the returned string. Any parameter can be a variable containing the appropriate values. Abbreviation : Mid ...
by adroege
Tue Jun 28, 2011 2:11 pm
Forum: Technical / Scripting
Topic: Date Calulations
Replies: 7
Views: 6256

The VBStart and VBEnd can go anywhere. Just put them at the very top of your code and forget about them. Having them in the script is just a hint to Macro Scheduler that it will need to use the VBScript module at some point.

It is the VBEval> that does the work of adding the interval to the date.
by adroege
Tue Jun 28, 2011 1:48 pm
Forum: Technical / Scripting
Topic: Date Calulations
Replies: 7
Views: 6256

Try this...

Code: Select all

VBStart
VBEnd

VBEval>DateAdd("d",31,Date),result
MessageModal>result
by adroege
Wed Jun 15, 2011 5:03 pm
Forum: Technical / Scripting
Topic: compare excel and notepad
Replies: 2
Views: 4750

This should get you going in the right direction. //Open Excel XLOpen>s:\xfer\alan\compare.xls,0,xlBook XLGetSheetDims>xlBook,Sheet1,maxrows,maxcols //Read notepad file Let>k=1 Label>start ReadLn>c:\temp\test.txt,k,line If>line=##EOF##,finish Gosub>SearchExcel If>foundit=1 //only uncomment this when...
by adroege
Fri Jun 03, 2011 2:01 pm
Forum: Technical / Scripting
Topic: How to Hibernate Your PC (Solution)
Replies: 14
Views: 13367

How can I speed up Windows Vista resume from hibernate?

Use standby instead of hibernate. The only difference is a small amount of power is used to keep RAM alive while in standby, cpu,hard drive, etc are still powered down (like hibernate).
by adroege
Thu Jun 02, 2011 7:26 pm
Forum: Technical / Scripting
Topic: If screen reads "out of actions", then send text
Replies: 5
Views: 4995

The screen looks like a mainframe terminal emulator (maybe 3270?). Many programs of this type have special API functions accessible by DLL calls to retrieve the text on the screen. This method would be more reliable than simple image recognition. As for looping.... here is a simple example of loopin...
by adroege
Thu Jun 02, 2011 7:24 pm
Forum: Technical / Scripting
Topic: If screen reads "out of actions", then send text
Replies: 5
Views: 4995

The screen looks like a mainframe terminal emulator (maybe 3270?). Many programs of this type have special API functions accessible by DLL calls to retrieve the text on the screen. This method would be more reliable than simple image recognition. As for looping.... here is a simple example of loopin...
by adroege
Thu May 26, 2011 2:26 pm
Forum: Beginners
Topic: How to make macro waiting beteween commands ?
Replies: 2
Views: 4732

make this macro to not execute a command till the command above it has finished. From the Help File -------- By setting the RP_WAIT variable to 1 prior to issuing the Run Program command the script will wait until the program launched by Run Program has terminated before continuing. The default val...
by adroege
Tue May 17, 2011 7:46 pm
Forum: Technical / Scripting
Topic: combine each line ?
Replies: 2
Views: 3731

Try this c:\temp\test.txt = multi-line file c:\temp\test2.txt = all on one line comma delimited Let>outline= Let>k=1 Label>start ReadLn>c:\temp\test.txt,k,line If>line=##EOF##,finish Let>outline=%outline%%line%, Let>k=k+1 Goto>start Label>finish WriteLn>c:\temp\test2.txt,result,%outline%
by adroege
Fri May 13, 2011 5:18 pm
Forum: Technical / Scripting
Topic: Loop with variable
Replies: 5
Views: 5549

Ok, now please post your code (including the "include") so that we can help you debug. The only reason to use include this way, is if you use the exact same code in more than one macro file.... otherwise it might be better coded as a subroutine (see Gosub and SRT and End in the help file) After you ...
by adroege
Tue May 10, 2011 8:11 pm
Forum: Technical / Scripting
Topic: Retrieving text from a minimized window
Replies: 4
Views: 5220

This should help you out //You are doing something like this already //GetControlText>WindowTitle,ClassName,Instance,Result //I'm simulating getcontroltext by just putting the output in a "result" variable Let>result=[23:03:45] <bot1> test1%CRLF%[23:03:47] <bot1> test2%CRLF%[23:03:49] <bot1> test3%C...
Sign up to our newsletter for free automation tips, tricks & discounts