Search found 56 matches

by evangelmike
Sun Nov 01, 2009 4:09 am
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 11508

Necessity of 2 StringReplaces before use CleanString

Hi Marcus! Thanks for your kind help. It is interesting to note that if I omit either a StringReplace to remove blanks or a StringReplace to remove to remove the appended CRLF, I get the message "Error in Position Command" when I run the below instructions. Why would that be? If I include the String...
by evangelmike
Fri Oct 30, 2009 4:34 pm
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 11508

Thanks greatly! But still a slight problem

Greetings! Thanks immensely! I modified my code as follows. It works great when "right"=193. But if "right" is 194, there is an extra nonprintable character at the end of the string sPriceCRLF, which none of the below logic will remove. I really need to use 194 so I can accomodate larger stock price...
by evangelmike
Fri Oct 30, 2009 6:19 am
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 11508

Converting Text to Numeric

Greetings! I am writing a macro to pick the stock price off a web page. The following instructions indeed pick the stock price, but the result is text instead of numeric. My instructions are: GetTextInRect>162,404,198,423,sPriceCRLF StringReplace>sPriceCRLF, ,,PriceCRLF StringReplace>PriceCRLF,CRLF,...
by evangelmike
Sun Dec 14, 2008 5:07 am
Forum: Technical / Scripting
Topic: SetFocus Problem with comment by Microsoft Tech Support
Replies: 2
Views: 4203

SetFocus Problem with comment by Microsoft Tech Support

Note: Comment by Microsoft Tech Support Engineer is at the end of this post in a PPS. Greetings! The operating system on my computer is Windows Vista, and I am using Macro Scheduler Version 11. Under certain circumstances, a macro which uses the following code to change focus from one Excel 2007 wor...
by evangelmike
Wed Dec 10, 2008 12:58 pm
Forum: Technical / Scripting
Topic: Property Loss when attempting to copy Macro Scheduler Files
Replies: 1
Views: 3286

Property Loss when attempting to copy Macro Scheduler Files

Greetings! I am currently using Macro Scheduler Version 11. My operating system is Windows Vista. When I try to copy any macro files I have edited (since upgrading to Ver. 11) to Amazon Web Services, I get the following message: "Property Loss Are you sure you want to copy this file without its prop...
by evangelmike
Tue Dec 09, 2008 5:51 pm
Forum: Technical / Scripting
Topic: Repeating a Reverse Search not working in Macro Scheduler 11
Replies: 0
Views: 2827

Repeating a Reverse Search not working in Macro Scheduler 11

Greetings! Using Macro Scheduler 11, Ctrl-f can be used to do either a forward or a reverse search. F3 is used to repeat a forward search. What would one use to repeat a reverse search? F3 won't do that on my machine. What key command should one use to repeat a reverse search? Thanks! May you have a...
by evangelmike
Wed Oct 01, 2008 1:46 am
Forum: Technical / Scripting
Topic: Ran into problem with Workbooks.Open
Replies: 0
Views: 3389

Ran into problem with Workbooks.Open

The problem described below has been solved. The VBA macro described below is called via a CTRL-SHIFT-P. But when the shift key is held down like this in calling any macro which has a Workbooks.Open command, the Workbooks.Open command is killed, and execution of the macro is stopped. The infuriating...
by evangelmike
Tue Sep 30, 2008 12:50 am
Forum: Technical / Scripting
Topic: Called Macro drops last 2 characters (CRLF) of parameter
Replies: 0
Views: 2879

Called Macro drops last 2 characters (CRLF) of parameter

Greetings! This one took me two hours to find. When a string whose last two characters are CRLF, is passed by one macro as a value to a second called macro, the CRLF characters are dropped from the string. Only the string is passed. CRLF is discarded. This can be verified by running CallingMacro and...
by evangelmike
Tue Sep 16, 2008 10:05 pm
Forum: Technical / Scripting
Topic: During install "Failed to Read Setup Engine"
Replies: 1
Views: 7932

During install "Failed to Read Setup Engine"

Greetings! While trying to install the very latest version of Macro Scheduler, I got the message "Launcher Error. Failed to read setup engine". The error is repeatable. The computer is a Lenovo with Vista Business. Does anyone have any ideas as to how I should proceed? Thanks! Sincerely, Michael D F...
by evangelmike
Wed Sep 03, 2008 7:52 pm
Forum: Enhancement Suggestions
Topic: Macro Scheduler for the Global Hosted Operating System
Replies: 0
Views: 4233

Macro Scheduler for the Global Hosted Operating System

It would be nice if Macro Scheduler could be made available on the Global Hosted Operating System (the wave of the future). Most likely this or a similar Web Based Operating System will replace Windows for all purposes after about 2014. A brief description: "G.ho.st (the Global Hosted Operating Syst...
by evangelmike
Tue Sep 02, 2008 1:14 am
Forum: Technical / Scripting
Topic: Argument of Repeat Until can't handle Scientific Notation
Replies: 0
Views: 2755

Argument of Repeat Until can't handle Scientific Notation

When Excel spreadsheet cells are set to numbers in Scientific Notation, and these values are read by a Macro Scheduler macro, the compare in the Until statement of a Repeat-Until loop, returns an error when the condition in the Until statement involves a compare against a number expressed in Scienti...
by evangelmike
Fri Aug 29, 2008 3:32 am
Forum: Technical / Scripting
Topic: Running 2 Macro Schedule Macros concurrently
Replies: 2
Views: 3657

Running 2 Macro Schedule Macros concurrently

Greetings! I would like to run a very long macro which, after running a few minutes, would call a second macro and then wait for a window having DONE as the first four letters of the window name. This would be done by using the instruction: WaitWindowOpen>DONE* The second macro which would run concu...
by evangelmike
Thu Aug 28, 2008 7:36 pm
Forum: Technical / Scripting
Topic: My large Macro Scheduler Macro won't run with IE8 Beta 2
Replies: 5
Views: 6287

WebRecorder offers a ContainsText function

Greetings! Thanks for the good info on ContainsText and GetWindowTextEx. My major concern here, is making 222 changes to a completely debugged set of macros. Not only will it take about 20 hours work to make and test these 222 changes, but I anticipate that it will probably take about an additional ...
by evangelmike
Thu Aug 28, 2008 5:20 pm
Forum: Technical / Scripting
Topic: My large Macro Scheduler Macro won't run with IE8 Beta 2
Replies: 5
Views: 6287

Replies to bnc1 and Me_again

Reply to bnc1 question: I visited about 7 websites with IE8 Beta 2 in Compatibility Mode, and it worked great with those websites. But because of its different implementation of the F3 Find, I am unable to use it, and I removed it from my computer. Therefore I did not even try to use it in IE 8 Nonc...
by evangelmike
Thu Aug 28, 2008 4:00 am
Forum: Technical / Scripting
Topic: My large Macro Scheduler Macro won't run with IE8 Beta 2
Replies: 5
Views: 6287

My large Macro Scheduler Macro won't run with IE8 Beta 2

Greetings! I thought you all would be interested in a Bug Report I wrote against IE8 Beta 2. To compact the code a bit, for the purposes of the Bug Report, I put comments on the same line as the code (which hopefully will be implemented in some future version of Macro Scheduler). I previously submit...
Sign up to our newsletter for free automation tips, tricks & discounts