| Author |
Message |
Forum: Support Topic: [SOLVED]IE9 has trouble with COM, ACC with HTML5 doctype |
| CodeRage |
|
Posted: November 10th, 2011, 3:33 pm
|
|
Replies: 22
Views: 924
|
Not sure, I never searched MSDN on the issue. I came upon it when I was verifying all of my DOM paths with IEWebDeveloperV2 plugin. I'll see what I can find though.
With this in mind, do you know of an easy way to detect browser version for workaround code? |
|
 |
Forum: Support Topic: [SOLVED]IE9 has trouble with COM, ACC with HTML5 doctype |
| CodeRage |
|
Posted: November 9th, 2011, 7:05 pm
|
|
Replies: 22
Views: 924
|
| I found this thread looking for info on a problem I'm having with ahk_L scripts for IE. Some scripts that I originally wrote/tested under IE8 won't work at all under IE9. I figured out what was wrong, just thought I'd share in case you run into the same snag. I discovered that in IE8 where all DOM e... |
|
|
Forum: Support Topic: COM and Excel - using QueryTables |
| CodeRage |
|
Posted: November 19th, 2010, 4:48 pm
|
|
Replies: 7
Views: 521
|
| Revisiting this topic, I again found a need to create a QueryTable through COM, and I found some success with this: XL_ImportSheets(csvfile) { COM_Init() xl := COM_CreateObject("Excel.Application") COM_Invoke(xl, "Visible", True) COM_Invoke... |
|
|
Forum: Scripts Topic: AHKIDE Project (discontinued) |
| CodeRage |
|
Posted: August 13th, 2010, 12:46 pm
|
|
Replies: 155
Views: 14590
|
| Sorry drifter, I never saved a txt file of that error, so I can't repost it, the only copy that exists should be in your inbox. I'll put on ahk fileserver next time and link to it. Anyway, I got this error which forced shutdown of the app while using 0.9.6 .. I was test-editing an existing script of... |
|
|
Forum: Support Topic: CryptoTerm (COM+) |
| CodeRage |
|
Posted: August 13th, 2010, 12:02 pm
|
|
Replies: 0
Views: 1884
|
| Hello all, I found a freeware terminal emulator called CryptoTerm that has a COM+ interface, which I believe may be a great solution for many of us who have been looking for a way to automate terminal emulation through AHK. However, I'm vastly underskilled at working with COM (or API's in general), ... |
|
|
Forum: Scripts Topic: AHKIDE Project (discontinued) |
| CodeRage |
|
Posted: August 6th, 2010, 12:42 pm
|
|
Replies: 155
Views: 14590
|
| It crashed again, but this time not right at startup, just soon after. I started typing a little bit of code and then it went. I used some AHK to copy the text of the microsoft error report, I'll have to send it to you in email or PM, the brackets inside it are screwing with the bbcode and it won't ... |
|
|
Forum: Scripts Topic: AHKIDE Project (discontinued) |
| CodeRage |
|
Posted: August 5th, 2010, 8:06 pm
|
|
Replies: 155
Views: 14590
|
Crashed on first run for me too, unable to copy error text though. Can't wait for a stable build, this looks awesome  |
|
|
Forum: Support Topic: COM/Excel - importing VBA code |
| CodeRage |
|
Posted: June 28th, 2010, 8:14 pm
|
|
Replies: 0
Views: 361
|
| I'm trying to utilize the Excel_ImportCode() function from the MS Office thread , but I can't seem to get a pointer to VBProject, not with the provided example code or my own. My test code: COM_Init() xl := COM_CreateObject("Excel.Application") COM_Invoke(xl, "Work... |
|
|
Forum: Support Topic: COM/Excel - using RemoveDuplicates |
| CodeRage |
|
Posted: June 21st, 2010, 12:13 am
|
|
Replies: 4
Views: 400
|
Aye, I read that in another thread after the fact so I snipped out the newb question  Still a bit over my head anyway.
Now I'm doing some nifty stuff with borders, thanks to this thread. |
|
|
Forum: Support Topic: COM/Excel - using RemoveDuplicates |
| CodeRage |
|
Posted: June 20th, 2010, 9:34 pm
|
|
Replies: 4
Views: 400
|
| Hey thanks for the speedy reply jethrow, that is exactly what I needed! Strange thing though.. I had success with this: COM_Invoke(xl, "ActiveSheet.Range('A1:H204').Select") COM_Invoke_(xl, "Selection.RemoveDuplicates", 0x200C, arr, 3, 2) But for some reas... |
|
|
Forum: Support Topic: COM/Excel - using RemoveDuplicates |
| CodeRage |
|
Posted: June 18th, 2010, 7:57 pm
|
|
Replies: 4
Views: 400
|
| I am trying to use Excel's Remove Duplicates method through COM, but getting stuck on syntax. Here is the VBA code I recorded: ActiveSheet.Range("$A$1:$H$204").RemoveDuplicates Columns:=Array(2, 4, 6, 7), Header:=xlNo This code filters duplicates according to a specific 4 c... |
|
|
Forum: Support Topic: COM and Excel - using QueryTables |
| CodeRage |
|
Posted: June 18th, 2010, 7:49 pm
|
|
Replies: 7
Views: 521
|
Hey thanks for the help, that is good information for other things later on. Fortunately, I solved my problem with another technique of simply writing everything to cells enclosed in quotes, then doing a mass-replace before saving. This seems to keep Excel from screwing with my data.
Thanks, all! |
|
|
Forum: Support Topic: COM and Excel - using QueryTables |
| CodeRage |
|
Posted: April 28th, 2010, 12:55 pm
|
|
Replies: 7
Views: 521
|
| Which function, QueryTables? It is just a data import. I'm trying to automate importing data from a CSV file into another workbook. |
|
|
Forum: Support Topic: COM and Excel - using QueryTables |
| CodeRage |
|
Posted: April 27th, 2010, 7:12 pm
|
|
Replies: 7
Views: 521
|
| Hi All, I'm having some difficulty executing a QueryTables.Add in Excel through COM, I need some help :( here is the test code I'm trying to make work, selectedfile is the source csv I'm trying to import into the new sheet, inputfile is the new sheet. The whole reason for doing this instead of simpl... |
|
|
Forum: Scripts Topic: Security Tool (hijackware) remover |
| CodeRage |
|
Posted: January 12th, 2010, 2:15 pm
|
|
Replies: 2
Views: 1107
|
| Thanks for the kind word Indeed, I considered that the integer issue may cause some havoc, but I reasoned that those cases are rare, plus any software using numeric-only processes may be malicious as well. Even so, it would be a small price to pay to rid a system of this foul program. |
|
|
| Sort by: |
Login
Register
FAQ
Search