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.
Search found 8 matches
- Tue Aug 09, 2011 2:38 pm
- Forum: Technical / Scripting
- Topic: Methods for Accessing Excel Data
- Replies: 7
- Views: 9691
- 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
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
- 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...
- 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?...
- 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
the results were all capital TRUE and FALSE
- 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 ...
- 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
- Wed Aug 29, 2007 11:01 pm
- Forum: Technical / Scripting
- Topic: V9 Telnet
- Replies: 19
- Views: 25093