Search found 8 matches

by sunole
Tue Aug 09, 2011 2:38 pm
Forum: Technical / Scripting
Topic: Methods for Accessing Excel Data
Replies: 7
Views: 9691

Re: Faster execution times if VBA reads and writes cells

I am using Copy for many cell range to clipboard, and pass it into variable to get faster access, it take almost zero seconds for this line with many cells

xlSheet.Range("A3:C200").Copy

also I have the app invisible and not effecting the system (Except clipboard not available).
xlApp.visible=false.
by sunole
Tue Jun 28, 2011 5:37 am
Forum: Technical / Scripting
Topic: code stops during run
Replies: 2
Views: 3327

easy way to abort or OK

is there an easy way to just click the abort or the OK, that would be much easier,

I tried to make a script that waits for the "Macro Scheduler" window to click the abort, but it get confused with which window to look at, this main script or this window that could pop up, help, thanks in advance
by sunole
Thu Jun 16, 2011 6:21 am
Forum: Technical / Scripting
Topic: code stops during run
Replies: 2
Views: 3327

code stops during run

I have this sample of code below which is called from VBEval> , it runs fine all day, but sometimes the macro stops with error window (title Macro Scheduler) and inside the window: :-2147467259 Line 13, Column 2 ( OK ) (Abort) this breaks automation, line 13 is the Set IE line. I already have in the...
by sunole
Mon Jan 12, 2009 5:39 pm
Forum: Technical / Scripting
Topic: doesn't run at window open??
Replies: 4
Views: 5602

doesn't run at window open??

I am using Version 11.0.32 i configure the script trigger to "window event","window open", "Calculator" uncheck only when visible the script it: MessageModal> saw it The Message does not show up when Calculator is opened but it shows when claculator is closed. shouldn't the scrip run at window open?...
by sunole
Thu Dec 04, 2008 7:48 pm
Forum: Beginners
Topic: passing variable from command line
Replies: 2
Views: 4250

that worked

thank you for your help, that worked well,
the results were all capital TRUE and FALSE ;-)
by sunole
Wed Dec 03, 2008 2:28 am
Forum: Beginners
Topic: passing variable from command line
Replies: 2
Views: 4250

passing variable from command line

I am trying to check if a variable exists since it has being passed from the command line, but the string that gets checked against it self and the logic result is always true if>%dest%true Endif In the above you get true because dest%dest%="" MessageModal>true Endif it is false because dest"" this ...
by sunole
Wed Sep 05, 2007 10:39 pm
Forum: Technical / Scripting
Topic: TelnetSend
Replies: 3
Views: 5148

telnet wait for sec or msec??

is this true that the timeout is in ms?? the documentation says the timeout is in seconds, and it looks to me that it is in seconds too, but i am not sure. please let me know, thanks
by sunole
Wed Aug 29, 2007 11:01 pm
Forum: Technical / Scripting
Topic: V9 Telnet
Replies: 19
Views: 25093

mtettmar wrote:Yes, just specify CR. CR is a built in variable for carriage return:

TelnetWaitFor>hTN,CR,5,r
just watch that the first CR you read is the CR you have sent after your previews command, so look for the second CR or read line by line with each CR untill the buffer is empty/quiet.
Sign up to our newsletter for free automation tips, tricks & discounts