Search found 56 matches
- 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...
- 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...
- 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,...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...