Search found 7 matches

by CodeFourSDSO
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...
by CodeFourSDSO
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...
by CodeFourSDSO
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...
by CodeFourSDSO
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...
by CodeFourSDSO
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...
by CodeFourSDSO
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!
by CodeFourSDSO
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...

Go to advanced search