Search found 56 matches

by evangelmike
Sun Aug 10, 2008 12:25 am
Forum: Technical / Scripting
Topic: Repeat Until Occasionally Fails to Exit
Replies: 2
Views: 3106

Complex Expresssion in Repeat Until Yields Odd Result

Greetings! I wrote and executed the following macro with a very surprising result: [code] Let>MxNrRngs=3 Let>SRanges=0 Repeat>SRanges Let>SRanges=SRanges+1 If>SRanges>3 MessageModal>SRanges = %SRanges%, MxNrRngs = %MxNrRngs% Wait>0.4 Goto>ExitRepeat Endif Wait>0.2 Until>{%SRanges%>%MxNrRngs%-1} Mess...
by evangelmike
Sat Aug 09, 2008 9:14 pm
Forum: Technical / Scripting
Topic: Repeat Until Occasionally Fails to Exit
Replies: 2
Views: 3106

Repeat Until Occasionally Fails to Exit

NOTE: I previously had listed the code as modified (incorrectly it turns out) in an attempt to solve the original 15% failure to exit the Repeat Loop properly problem. The original code with the Repeat Until loop which would not exit properly is listed below. The only difference between the two sets...
by evangelmike
Mon Jul 21, 2008 3:45 am
Forum: Technical / Scripting
Topic: Suspect Anomaly-<End> disabled by CapsOff
Replies: 5
Views: 5391

End works fine on my keyboard

Greetings! I have at least 16 Macro Scheduler macros which use the CapsOff instruction and the End key works just fine on my keyboard.
by evangelmike
Sat Jul 19, 2008 5:10 am
Forum: Technical / Scripting
Topic: Interrupt a stalled Page Load to do a Refresh on IE Page.
Replies: 14
Views: 14231

You might try: [code] Let>WW_TIMEOUT=5 LibFunc>hIE,Navigate,r,%IE[0]%,http://www.microsoft.com Label>TryAgain WaitWindowOpen>Microsoft Corporation - Windows Internet Explorer // WWO Times out after 5 secs. If it Times out, check WW_RESULT. // If set to FALSE, refresh page. If>WW_RESULT=FALSE GoSub>R...
by evangelmike
Wed Jul 09, 2008 7:46 pm
Forum: Technical / Scripting
Topic: DDERequest: Default Excel worksheet when none specified
Replies: 3
Views: 3864

Greetings! Further testing reveals that one may add a new worksheet anywhere within a collection of worksheets--i.e. at the beginning of a collection of worksheets, anywhere in the middle, or at the end of a collection of worksheets. (One adds a new worksheet by rightclicking on any of the worksheet...
by evangelmike
Wed Jul 09, 2008 3:40 pm
Forum: Technical / Scripting
Topic: DDERequest: Default Excel worksheet when none specified
Replies: 3
Views: 3864

Greetings! I ran a DDEPoke test on my file BookIssuersChgd.xlsm. The first worksheet of BookIssuersChgd.xlsm has no data, and the next 22 worksheets have data. I ran the following macro both with the focus set to BookIssuersChgd.xlsm, and with the focus set to another workbook: [code] SetFocus>BookI...
by evangelmike
Wed Jul 09, 2008 4:11 am
Forum: Technical / Scripting
Topic: DDERequest: Default Excel worksheet when none specified
Replies: 3
Views: 3864

DDERequest: Default Excel worksheet when none specified

Greetings! One of the blogs has the following: "Use the DDERequest command to retrieve an item of data from Excel. Excel must be running and the spreadsheet must already be open. We could easily make our macro open the worksheet for us using the ExecuteFile command (or Run Program). We then use DDER...
by evangelmike
Thu Jun 19, 2008 10:35 pm
Forum: Technical / Scripting
Topic: Wait Cursor Ready
Replies: 3
Views: 4256

Use of WaitCursorChange to detect completion of File Save

I spoke way too quickly. In the few programs I have checked so far, WaitCursorChanged can be used to detect completion of the save operation in Excel and WordPad, but not in NotePad or Microsoft Word 2007. For these two programs (and probably many others), other methods of determining completion of ...
by evangelmike
Wed Jun 18, 2008 11:31 pm
Forum: Technical / Scripting
Topic: Wait Cursor Ready
Replies: 3
Views: 4256

WaitCursorChanged used after a file save

When a Macro Scheduler macro is saving a large file, and you want to be sure that the file save has completed before allowing the macro to continue with its processing, one can use WaitCursorChanged to accomplish this as follows: [code] Let>SaveWait=10 SetFocus>(on the file to be saved) WaitReady> W...
by evangelmike
Mon Jun 16, 2008 9:40 pm
Forum: Technical / Scripting
Topic: Methods for Accessing Excel Data
Replies: 7
Views: 8953

Faster execution times if VBA reads and writes cells

One can minimize execution time if, as much as possible, reads and writes of Excel Cells are done in VBA rather than in any of the ways of doing so in Macro Scheduler. To investigate this matter, I performed reading and writing an Excel cell 1000 times in VBA as shown below. It took less than 1.2 se...
by evangelmike
Tue Jun 10, 2008 6:19 am
Forum: Technical / Scripting
Topic: Wait Cursor Ready
Replies: 3
Views: 4256

Wait Cursor Ready

Greetings! When program control arrives at a certain pont in my macro, there are two possibilities: 1) The cursor may not be busy. In this case I wish to proceed with the rest of the processing immediately. 2) The cursor may be busy for up to 5 minutes. If I use the WaitCursor Changed instruction to...
by evangelmike
Sat Jun 07, 2008 11:38 pm
Forum: General Discussion
Topic: How to launch a MS macro from a VBA program?
Replies: 3
Views: 7613

Greetings! If one does not want a DOS Window to open, one can also use ShellExecute in VBA as follows: [code] Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA" (ByVal hWnd As Long, _ ByVal lpOperation As String, ByVal lpFile As String, _ ByVal lpParameters As String, By...
by evangelmike
Sat Jun 07, 2008 7:28 am
Forum: General Discussion
Topic: Send> and %CR%
Replies: 2
Views: 4846

But please remember that if data is a variable, it must be enclosed by %'s:

[code]
Let>data=abc
Let>data1=defg
Send>%data%%CR%%data1%%CR%
[/code]

Of course if data is itself a constant or a string (such as abc or defg), this becomes:

[code]
Send>abc%CR%defg%CR%
[/code]
by evangelmike
Fri Jun 06, 2008 6:18 pm
Forum: Technical / Scripting
Topic: Problem with Input Instruction Logic
Replies: 6
Views: 5114

Greetings! The first sentence of my previous post has a typo and is not clear. It should read:
I clicked Disable HTML, BBCode, and Smilies, but doing Preview shows these Options as still all On.
by evangelmike
Fri Jun 06, 2008 5:53 pm
Forum: Technical / Scripting
Topic: Problem with Input Instruction Logic
Replies: 6
Views: 5114

Unable to turn HTML, BBCode, and Smilies

Greetings! I tried clicking the Disable HTML, BBCode, and Smilies, and doing Preview ahows these Options as still all on. For example, having disabled these, I now try to post my original code, but as you can see, the Not-Equals sign still does not display correctly in my code: (YES is still display...
Sign up to our newsletter for free automation tips, tricks & discounts