 |
AutoHotkey Community Let's help each other out
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in| Search found 16 matches |
| Author | Message |
|---|---|
 Topic: Count Lines in a File |
|
| Andrew Replies: 1 Views: 298 |
 Forum: Ask for Help Posted: Tue Oct 24, 2006 4:49 am Subject: Count Lines in a File |
| I would like to count the lines in an Excel spreadsheet and delete the file if it only has one line. Is this something I can do with AutoHotkey (without opening Excel)? Thanks in advance for any rep ... | |
| Topic: Invoke Excel Macro |
|
| Andrew Replies: 11 Views: 772 |
Forum: Ask for Help Posted: Mon Oct 23, 2006 2:47 pm Subject: Invoke Excel Macro |
| I ended up using PhiLho's suggestion and doing it from within Excel. It worked better than I thought it would. Meanwhile, I also learned what WindowSpy is, so thanks to both of you for teaching me m ... | |
| Topic: Invoke Excel Macro |
|
| Andrew Replies: 11 Views: 772 |
Forum: Ask for Help Posted: Sun Oct 22, 2006 6:11 pm Subject: Invoke Excel Macro |
| PhiLho, you are correct, but I think for my case, Conquer's method might work better. That is, if I can make it work. I found that WindowSpy is a program that was installed with AutoHotkey, so I'm h ... | |
| Topic: Invoke Excel Macro |
|
| Andrew Replies: 11 Views: 772 |
Forum: Ask for Help Posted: Sun Oct 22, 2006 4:02 am Subject: Invoke Excel Macro |
| I'm sorry for my ignorance, but I'm not familar with the terms 'windowspy' and 'ahk_class'. I also don't know what you mean by 'works once'. Shouldn't it continue to work each time it's invoke? I w ... | |
| Topic: Invoke Excel Macro |
|
| Andrew Replies: 11 Views: 772 |
Forum: Ask for Help Posted: Sat Oct 21, 2006 10:48 pm Subject: Invoke Excel Macro |
| This seems like a really simple question, but I searched around this forum and didn't see a clear answer, so here it is...
How do I force a VBA script to execute when Excel is started with the Run ... |
|
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Wed Oct 18, 2006 9:55 pm Subject: Passing a Variable to Excel |
| Ahhh, the FileAppend command. Thanks so much. All of those who answered my question were giving me too much credit for asking a complex question. It was actually much simpler than you all were thin ... | |
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Wed Oct 18, 2006 1:38 pm Subject: Passing a Variable to Excel |
| Thanks for your replies. In case it's not obvious, I'm very much a noobie to all of this. I'm not even a programmer by trade. I don't necessarily need to use the EnvSet command. I just want to pas ... | |
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Wed Oct 18, 2006 12:14 pm Subject: Passing a Variable to Excel |
| OK, maybe I just don't know how to do it. My AutoHotkey script contains:
INTMX=value1 EnvSet,INTMX Run, Excel.exe Once Excel is open, I run a VBA script that contains: Sub Macro1() MsgBox ... |
|
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Tue Oct 17, 2006 1:43 pm Subject: Passing a Variable to Excel |
| Thanks, PhiLho. That's what I don't know how to do... "put the needed info in cells of this sheet". The variables have been assigned a value in AutoHotkey and I want Excel to read the valu ... | |
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Mon Oct 16, 2006 1:10 pm Subject: Passing a Variable to Excel |
| Can anyone tell me how it's done or point me to some documentation on the subject? Thanks. | |
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Sun Oct 15, 2006 11:40 pm Subject: Passing a Variable to Excel |
| OK, I'll bite. How do I do it?
I'm writing a VBA subroutine to process a bunch of files in Excel. The quantity of files and file names change daily. VBA doesn't appear to have an "ifexist ... |
|
| Topic: Passing a Variable to Excel |
|
| Andrew Replies: 18 Views: 2999 |
Forum: Ask for Help Posted: Sun Oct 15, 2006 11:19 pm Subject: Passing a Variable to Excel |
| Is it possible to pass a variable to Excel so it can be used by a VBA subroutine? Thanks. | |
| Topic: Working with Ranges in Excel |
|
| Andrew Replies: 7 Views: 591 |
Forum: Ask for Help Posted: Thu Oct 12, 2006 7:57 pm Subject: Working with Ranges in Excel |
I should have Google'd before posting. It appears you are either talking about the Veterans Benefits Administration or Visual Basic for Applications. I think I'll explore the latter.  |
|
| Topic: Working with Ranges in Excel |
|
| Andrew Replies: 7 Views: 591 |
Forum: Ask for Help Posted: Thu Oct 12, 2006 7:53 pm Subject: Working with Ranges in Excel |
| I have a lot of operations to perform within Excel, but I don't know what VBA is. Is it something I can learn quickly to help perform my Excel operations? | |
| Topic: Specific AutoHotkey Capabilities |
|
| Andrew Replies: 3 Views: 230 |
Forum: Ask for Help Posted: Tue Oct 10, 2006 11:32 pm Subject: Specific AutoHotkey Capabilities |
| Thanks for the replies, Titan and Bobo. I had overlooked the FileExist() function. That is exactly what I was looking for. I found some good information at http://www.autohotkey.com/docs/Functions. ... | |
All times are GMT |
Powered by phpBB © 2001, 2005 phpBB Group