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...

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...

Greetings! I have at least 16 Macro Scheduler macros which use the CapsOff instruction and the End key works just fine on my keyboard.

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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]

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.

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...