Search found 7 matches
- 22 Feb 2018, 10:52
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop in Using Excel Data
SUCCESS!!!!!!!!! FG You're the best! THANK YOU SO MUCH! People at the office are losing their minds, they can't believe this was an alternative to manually inputting all this data :) I only had to make a few very small tweeks to get it going. One last kink to work out and it's good to go. If the dat...
- 21 Feb 2018, 16:16
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop in Using Excel Data
Perhaps this will clarify... This code works stand alone to retrieve data from the spreadsheet and move it into a database program (thanks to FG) xlApp := ComObjActive("Excel.Application") xlWS := xlApp.Sheets(1) row := 0 return Row := 1 Column := 1 F12:: xlApp := ComObjActive("Excel.Application") v...
- 21 Feb 2018, 10:07
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop using Excel Data
[/code][/code] Example: ; Starting Row and Column Row := 3 Column := 2 F12:: xlApp := ComObjActive("Excel.Application") val := xlApp.Cells(Row, Column).Value Row++ if !(val = "") SendRaw, % val else MsgBox DONE return With the source Excel sheet running (can be minimized whatever, AHK could open Exc...
- 20 Feb 2018, 17:53
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop in Using Excel Data
You don't need to Alt-Tab between Excel and your program. You can stay in your program and just pull the data from Excel as you need it. Excel never has to be active or even visible for that matter. It will save alot of trouble with the Alt+Tabbing. FG That sounds like some next level scripting I'd...
- 20 Feb 2018, 13:20
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop in Using Excel Data
Hi Odlanir, I have a few more questions if you have a moment I'd really appreciate your time. Assumptions: At the time I run the script command I have: -Excel running with the cell A1 selected -Proprietary database opened in the background with the cursor located at a user input cell. I will call th...
- 09 Feb 2018, 13:51
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Re: Creating and Ending a Loop in Using Excel Data
Odlanir, you are a wizard! I definitely could NOT have figured that out on my own! Thank you so much looking forward to playing with this and making it work. Really appreciate that prompt assistance though, very kind of you
Cheers!
Cheers!
- 09 Feb 2018, 12:47
- Forum: Ask for Help (v1)
- Topic: Creating and Ending a Loop in Using Excel Data
- Replies: 12
- Views: 3948
Creating and Ending a Loop in Using Excel Data
Hello, Brand new to AHK so apologies in advance for lack of experience/knowledge. Normally I'd crunch away on my own until I figured something out but it's a time crunch for a work project and I'm sure you guys/gals probably have a simple solution for me. I'm trying to create a script that will Copy...