| Author |
Message |
Forum: Custom Topic: [AHK_L] Powerful Math Expression Evaluation In One Go |
| flyingDman |
|
Posted: May 15th, 2012, 5:30 am
|
|
Replies: 11
Views: 1380
|
| I am getting either an empty string or something like the msgbox shown above. calc(6) should not return .57721566490153286060651209008246.5772156649015328606065120900824. When I remove the Const section, the results are correct. |
|
 |
Forum: Custom Topic: [AHK_L] Powerful Math Expression Evaluation In One Go |
| flyingDman |
|
Posted: May 14th, 2012, 9:02 pm
|
|
Replies: 11
Views: 1380
|
| Trying to find a replacement for Eval() / Monster as it does not work properly when scripts are compiled. Not much luck with Calc either as I am getting unwanted results. Launching msgbox % Calc(2+4) gives me this: http://www.keramigos.com/images/Capture_05-14-2012.JPG Removing the const := etc. sol... |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: May 4th, 2012, 8:14 pm
|
|
Replies: 12
Views: 471
|
| Although it's been almost 6 months ago since this post was "alive", I realize I never posted what I ended up with. COM_Invoke(oBook, "Sheets(1).Range[a63].PageBreak=", -4135) works just fine, and in "L" it becomes: xl.Sheets(1).Range("a63").PageBreak := -4135 ... |
|
|
Forum: Support Topic: Copying specific text from website and paste to excel. |
| flyingDman |
|
Posted: January 5th, 2012, 9:21 pm
|
|
Replies: 6
Views: 251
|
Have a look at this http://www.gummy-stuff.org/Yahoo-data.htm
You can run something like this:
Code: URLDownloadToFile,http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr,test.csv
run, test.csv
(using the example given) |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: November 13th, 2011, 11:33 pm
|
|
Replies: 12
Views: 471
|
@sinkfaze: thank you, but that did not seem to work. I am getting a Type Mismatch Error.
@Learning one: thank you, but I am a lazy bum and haven't moved to AHK_L yet, so I cannot test it. Maybe someone else knows the translation?
edit: Sorry did not see your addition. Let me try. |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: November 13th, 2011, 7:46 pm
|
|
Replies: 12
Views: 471
|
| Setting the print page width and height works smoothly thanks to Jethrow's help but I am still unable to set horizontal page breaks. I have tried each of the following (to set a pagebreak at the 40th row): COM_Invoke(oBook, "Sheets(1).HPageBreaks.Add=",40) COM_Invoke(oB... |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: October 15th, 2011, 8:04 am
|
|
Replies: 12
Views: 471
|
That did the trick! Thank you so much.  |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: October 14th, 2011, 9:12 pm
|
|
Replies: 12
Views: 471
|
| and, BTW, I am able to set the zoom level at any specific number, so that Code: COM_Invoke(oBook, "Sheets(1).PageSetup.Zoom",74)
works perfectly. I think the issue is that it does not recognizes "false" as value. Setting it to 0 or -1 does not help either. |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: October 14th, 2011, 8:30 pm
|
|
Replies: 12
Views: 471
|
| Thanks. Yes, I had done that a well but that did not change the result. |
|
|
Forum: Support Topic: Excel COM issues |
| flyingDman |
|
Posted: October 14th, 2011, 7:51 pm
|
|
Replies: 12
Views: 471
|
| I am trying to automate the creation of various Excel spreadsheets and collection of data from spreadsheets into access databases. The spreadsheets also need to be formatted so that they can be printed. I am able to set the margins, the orientation and the FitToPagesWide and FitToPagesTall as follow... |
|
|
Forum: Support Topic: how to display alot of data on the screen |
| flyingDman |
|
Posted: October 9th, 2011, 6:01 pm
|
|
Replies: 4
Views: 185
|
|
|
Forum: Support Topic: [solved]Eset Antivirus quarantining/deleting compiled script |
| flyingDman |
|
Posted: September 28th, 2011, 9:09 pm
|
|
Replies: 2
Views: 184
|
| Thank you. That seems to have been the problem. Renaming UPX.exe only grows the file by 10% or so. I can live with that. |
|
|
Forum: Support Topic: [solved]Eset Antivirus quarantining/deleting compiled script |
| flyingDman |
|
Posted: September 28th, 2011, 4:26 am
|
|
Replies: 2
Views: 184
|
| A colleague is not able to run a compiled script on his PC. As soon as he downloads it is deleted or quarantined by his Eset antivirus. It deletes from a flash drive as well. Is there a way to change Eset settings to avoid this? |
|
|
Forum: Scripts Topic: binary, hex and decimal converter |
| flyingDman |
|
Posted: September 17th, 2011, 5:58 pm
|
|
Replies: 3
Views: 544
|
|
|
Forum: Support Topic: Excel COM ActiveWorkbook.SaveCopyAs |
| flyingDman |
|
Posted: August 31st, 2011, 7:50 pm
|
|
Replies: 2
Views: 229
|
| Thank you! Works like a charm... |
|
|
| Sort by: |
Login
Register
FAQ
Search