Greetings! Apparently the 'Code' button does not correctly handle the not-equals symbol. So, in the below code, I had to use /= to stand in for the not-equals symbol. Also apparently, the logic that handles this Message Body text also has a problem with the Not-Equals symbol. Which means that both t...

Greetings! According to the manual's description of the Input instruction: "It is possible to set a timeout by setting the value of INPUT_TIMEOUT before issuing the Input command. INPUT_TIMEOUT takes a number of milliseconds. If the Input box is still active after the timeout has elapsed it will be ...

I performed a timing study in which I ran through the "Get-Set" cycle 1000 times for DDEPoke-DDERequest and VBScript's GetCell, SetCell, in order to see which set gives the fastest speed. The results shocked me. Reading and writing to Excel 1000 times using VBScript takes 42.4 seconds. Reading and w...

After much fiddling around, I discovered some logic involving GetObject which actually worked!!! I simplified things as much as possible by saving my workbook BookDates in my C root directory. Now I will gradually complicate things until I find something which does not work. (Programming is fun!!!) ...

Greetings! I have found that DDEPoke and DDERequest occasionally fail when attempting to write and read Excel spreadsheet cells, and have been using much slower Macro Scheduler subroutines to read and write in Excel. (The Macro Scheduler subroutines have never failed so far.) So I am hoping that I w...

Greetings! After a few hours trial and error, I failed to figure out how Section "3) VBScript via COM" of Marcus’ Macro Blog entitled "Methods for Accessing Excel Data" (July 2nd, 2007) would need to be modified if at the time one wants to use Functions GetCell and SetCell, Excel is already open a...

Greetings! Since I penned my last reply, I discovered that the solution I presented fails when a macro is calling a longer (or more complex) macro. After a bit of fiddling around I discovered a solution which seems to always work: The main macro would have: SetEnvVar>SetSTEP_DELAY,200 and the called...

Greetings! What are the disadvantages of using Environment Variables to set variables globally? For example, my main macro could create and set an Environment Variable named STEP_DELAY as follows: // Set STEP_DELAY to 200 ms SetEnvVar>STEP_DELAY,200 Then each of the 8 subordinate macros which are ca...

Greetings! I have a main macro which calls 8 other macros. Each of the subordinate macros needs a certain value. At present, the main macro sets an Excel spreadsheet cell, and each of the subordinate macros reads that cell. Since quite a bit of logic is involved in reading a spreadsheet cell and str...

Greetings! I have further researched native Boolean variables in Macro Scheduler. Consider the following code: Let>MyString=Stryng Let>Cat={%MyString%="Stryng"} // Thus the variable Cat should be a Boolean True If>{%Cat%=1} MessageModal>Cat3 is %Cat% Endif If>{%Cat%="TRUE"} MessageModal>Cat2 is %Cat...

Greetings! I have been researching whether there are native Boolean variables in Macro Scheduler. To do this, I executed the following code: Let>MyString=Stryng Let>Cat={%MyString%="Stryng"} // Thus the variable Cat should be a Boolean True If>{%Cat%="true"} MessageModal>Cat3 is %Cat% Endif If>{%Cat...