| Author |
Message |
Forum: Support Topic: Excel/COM - trouble adding, renaming, switching sheets |
| Gadrin |
|
Posted: September 29th, 2009, 3:41 pm
|
|
Replies: 19
Views: 1246
|
| However, I would love to be able to run those other built macros with the AHK script. How do I run a excel macro from ahk? Essentially the .Run method is simply part of the Excel.Application object in the Excel Object Model. I've done it in VBScript, VBA and Winbatch, but not in AHK. something like... |
|
 |
Forum: Support Topic: Fixed Width Strings |
| Gadrin |
|
Posted: September 29th, 2009, 3:33 pm
|
|
Replies: 8
Views: 245
|
temp01 wrote: Code: PadStr(str, size)
{
loop % size-StrLen(str)
str .= A_Space
return str
}
Okay that works.
Thanks 
> |
|
|
Forum: Support Topic: Fixed Width Strings |
| Gadrin |
|
Posted: September 29th, 2009, 4:23 am
|
|
Replies: 8
Views: 245
|
| Your StrPad didn't work. I came close with this but I get periods instead of spaces. No period doesn't pad anything. AHK whitespace/variable usage is much different than most programming languages. PadStr(str, size) { num := size-StrLen(str) loop %num% { str = %str%.%A_Spac... |
|
|
Forum: Support Topic: Fixed Width Strings |
| Gadrin |
|
Posted: September 29th, 2009, 3:28 am
|
|
Replies: 8
Views: 245
|
No I saw those, I think you misunderstand.
I want to Pad the strings so take a 10 char string and pad it to 25
with blanks on the right hand side so I can build a readable report.
So take "Fred" and make it "Fred__________"
> |
|
|
Forum: Support Topic: Fixed Width Strings |
| Gadrin |
|
Posted: September 29th, 2009, 3:22 am
|
|
Replies: 8
Views: 245
|
How do I format a string to a certain width ?
Most languages have built in functions to do this (either right or left)
but I didn't see anything in the help file (format or Strxxxxx functions).
Or do I have to build my own ?
Thanks. |
|
|
Forum: Support Topic: Illegal Variable Name |
| Gadrin |
|
Posted: September 26th, 2009, 10:40 pm
|
|
Replies: 2
Views: 204
|
Awesome! Thanks.
I would have never guessed that one.
>  |
|
|
Forum: Support Topic: Illegal Variable Name |
| Gadrin |
|
Posted: September 26th, 2009, 9:16 pm
|
|
Replies: 2
Views: 204
|
| I've written a script to build a ;-delim file so I can import it into MYSQL. Running it from the command line works fine, but AHK dies on: P:\AHK\Traveller-Inventory.ahk (20) : ==> The following variable name contains an illegal character: "size,@d) set fdate = str_to_date(@d,'%... |
|
|
Forum: Support Topic: Auto Hotkey and Explorer |
| Gadrin |
|
Posted: September 25th, 2009, 6:04 pm
|
|
Replies: 2
Views: 205
|
Ah, so far so good.
Thanks ! |
|
|
Forum: Support Topic: Auto Hotkey and Explorer |
| Gadrin |
|
Posted: September 25th, 2009, 1:05 am
|
|
Replies: 2
Views: 205
|
| I'm on Windows XP Pro sp2 or 3 by now. This probably isn't an AHK question but I don't know where to post it... I have an AHK shortcut to Start Explorer on a folder shared with another PC we have on our home network. Every once in a while I hit the combo and forget the other PC is off and nothing wi... |
|
|
Forum: Support Topic: getting the URL of a page without any change on the screen |
| Gadrin |
|
Posted: November 20th, 2008, 9:49 pm
|
|
Replies: 6
Views: 481
|
| Have AHK run a .VBS that will connect to MSIE and get the .locationURL of the page (and any other MSIE windows). Function AttachToMSIE(br) ' this will find all Explorers including Windows Explorer as ' well as MSIE, so we need to look at the .locationURL property ' to find the one on the win... |
|
|
Forum: Support Topic: Keyboard Shortcut for Different Windows |
| Gadrin |
|
Posted: November 20th, 2008, 4:05 pm
|
|
Replies: 2
Views: 1523
|
| Is it possible to have AHK detect when I have a certain App open and change the shortcut for my keyboard ? FREX: I use ALT-F11 to open Paint Shop Pro on my PC. However when I use MS Excel, I want to use ALT-F11 to open the VBA editor. My AHK stays in the tray all day, I'm just wondering if it can ch... |
|
|
Forum: Support Topic: Hiding AHK Icon |
| Gadrin |
|
Posted: November 14th, 2008, 6:33 pm
|
|
Replies: 0
Views: 376
|
| I have XP Pro SP3 and the START menu hides my .AHK icon that's running in the tray even after I told it not to START > Properties > Taskbar > Customize > Always show. Anyone have an idea how I can tell Windows not to hide my AHK script that's running ? I periodically have to right-click it and edit ... |
|
|
Forum: Support Topic: Which Control |
| Gadrin |
|
Posted: March 21st, 2007, 5:23 pm
|
|
Replies: 1
Views: 484
|
using the
FileSelectFile, SelectedFile, 3, , Open a file, Text Documents (*.txt; *.doc)
is great. Anyone know which DLL or API this uses ? |
|
|
Forum: Support Topic: Reading text from Chat Program |
| Gadrin |
|
Posted: February 25th, 2007, 5:57 pm
|
|
Replies: 3
Views: 623
|
hard to say exactly.
what browser are you using ?
you might be able to send key strokes up to the FILE menu and save the page as an HTML file, then parse the HTML for what you need. each time you do that, you overwrite the HTML file and it keeps parsing that file. |
|
|
Forum: Support Topic: Automated Script to Auto Extract Data Online--->HELP |
| Gadrin |
|
Posted: February 22nd, 2007, 11:00 pm
|
|
Replies: 2
Views: 602
|
| Hi there I am new to AHK, but I find this very interesting. I have a task that requries data extraction from a web page that I would like to automate and deposit into excel for further analysis. Is this the application to automate this function? hello, depends on what you're trying to do and how co... |
|
|
| Sort by: |
Login
Register
FAQ
Search