Search found 57 matches

by hidefguy
04 Feb 2018, 15:39
Forum: Ask For Help
Topic: Alternative to CTRL V
Replies: 16
Views: 2037

Re: Alternative to CTRL V

So double quotation is a No,No for my intention?
by hidefguy
04 Feb 2018, 12:54
Forum: Ask For Help
Topic: Alternative to CTRL V
Replies: 16
Views: 2037

Re: Alternative to CTRL V

Cool. Wouldn’t it be:

Send, %FileTo.Range(“A2”)%.value

Percent after (“A2”)?
by hidefguy
04 Feb 2018, 11:20
Forum: Ask For Help
Topic: Alternative to CTRL V
Replies: 16
Views: 2037

Re: Alternative to CTRL V

Thanks for that. Can I pass it as a value instead of copying to clipboard? Following this logic possibly:

FileTo.Range(“A2”).value
Send, valueofrangeA2
by hidefguy
04 Feb 2018, 08:34
Forum: Ask For Help
Topic: Alternative to CTRL V
Replies: 16
Views: 2037

Alternative to CTRL V

I’ve been using a combination of COM for MS tasks and keystrokes for third party software. On rare occasion, the CTRL +V doesnt insert copied value into third party GUI. I have it scripted like this: FileTo.Range(“A2”).copy Send, ^V Is there a more stable way to paste value into the third party GUI?
by hidefguy
02 Feb 2018, 20:04
Forum: Ask For Help
Topic: If,then,else condition
Replies: 2
Views: 448

Re: If,then,else condition

@Exaskryz

I posted a simplified variation of the target snippet, but yes, it does utilize COM scripting. And thank you very much for the sample code. Looks like it fits the bill.
by hidefguy
02 Feb 2018, 19:19
Forum: Ask For Help
Topic: If,then,else condition
Replies: 2
Views: 448

If,then,else condition

I’m trying to integrate this logic into my AHK project, but it doesn’t seem to work. I might be missing something simple. InputBox, @, Starting row number XXX.Range("G”@).copy YYY.Range(“A1”).paste If @>1 then XXX.Range("G”@).copy YYY.Range(“A2”).paste Else If @>2 then XXX.Range("G”@).copy YYY.Range...
by hidefguy
30 Jan 2018, 20:10
Forum: Ask For Help
Topic: ActiveCell Offset error
Replies: 14
Views: 2057

Re: ActiveCell Offset error

That is just the problem. You were not consistent, some places in the script had a number 1 and others had a letter l. Consistent means 100% consistent throughout ever use of the variable throughout the script. I admit with the font the forum uses in code blocks it is hard to tell them apart but on...
by hidefguy
30 Jan 2018, 10:13
Forum: Ask For Help
Topic: ActiveCell Offset error
Replies: 14
Views: 2057

Re: ActiveCell Offset error

FG Didn't realize I had a 1 in there, and although consistent, I changed it to an L so signify the Excel abbreviation. Seems you're right regarding the uncertainty of the ActiveCell location. This appears to be a problem when dealing with multiple open (FileFrom and FileTo) xlsx files. The goal was ...
by hidefguy
30 Jan 2018, 00:10
Forum: Ask For Help
Topic: ActiveCell Offset error
Replies: 14
Views: 2057

Re: ActiveCell Offset error

xlApp := ComObjActive("Excel.Application") FileTo_Path := A_Desktop "\Perm.xlsx" FileTo := xlApp.Workbooks.Open(FileTo_Path) FileFrom_Pattern := A_Desktop "\Test\*.xlsx" Loop, Files, % FileFrom_Pattern { FileFrom := xlApp.Workbooks.Open(A_LoopFileFullPath) if (A_Index = 1) { x1App.ActiveCell.Offset...
by hidefguy
29 Jan 2018, 02:38
Forum: Ask For Help
Topic: ActiveCell Offset error
Replies: 14
Views: 2057

ActiveCell Offset error

xlApp := ComObjActive("Excel.Application") FileTo_Path := A_Desktop "\Perm.xlsx" FileTo := xlApp.Workbooks.Open(FileTo_Path) FileFrom_Pattern := A_Desktop "\Test\*.xlsx" Loop, Files, % FileFrom_Pattern { FileFrom := xlApp.Workbooks.Open(A_LoopFileFullPath) if (A_Index = 1) { FileTo.Sheets(1).Range(...
by hidefguy
25 Jan 2018, 01:43
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Re: Copy cell values between Excel files without keystrokes

This will open your Perm file and then all xlsx files in your Test folder one at a time. The first one copies values to the G1 and H1 cells. All the ones past the first are copied to a cell offset by an increasing amount to the right so you end up with data going into G1, H1, I1, J1, etc. Each of t...
by hidefguy
24 Jan 2018, 21:24
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Re: Copy cell values between Excel files without keystrokes

Sweet! I’ll play around with it. I feel guilty for wasting your time with the guidance you’ve provided. At least let me make a donation to your favorite charity :) Before the ComObjActive copy script/loop even starts I’ve been using send, # to bring up the windows at lower tab. #1 is the software an...
by hidefguy
23 Jan 2018, 22:05
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Re: Copy cell values between Excel files without keystrokes

xlApp := ComObjActive("Excel.Application") xlApp.Visible := true FileTo_Path := A_Desktop "\Perm.xlsx" FileTo := xlApp.Workbooks.Open(FileTo_Path) FileFrom_Pattern := A_Desktop "\Test\1.xlsx" Loop, Files, % FileFrom_Pattern { FileFrom := xlApp.Workbooks.Open(A_LoopFileFullPath) FileTo.Sheets(1).Ran...
by hidefguy
22 Jan 2018, 23:53
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Re: Copy cell values between Excel files without keystrokes

xlApp := ComObjActive("Excel.Application") xlApp.Visible := true FileFrom_Path := A_Desktop "\Folder\Temp.xlsx" FileTo_Path := A_Desktop "\Perm.xlsx" FileFrom := xlApp.Workbooks.Open(FileFrom_Path) FileTo := xlApp.Workbooks.Open(FileTo_Path) FileTo.Sheets(1).Range("A2").value := FileFrom.Sheets(2)....
by hidefguy
22 Jan 2018, 15:57
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Re: Copy cell values between Excel files without keystrokes

Thanks again FG. I'll play around with it
by hidefguy
22 Jan 2018, 13:49
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 14
Views: 2090

Copy cell values between Excel files without keystrokes

I've tried to PM a couple guys here and commission them to code some tasks for me, but there has been some miscommunication, so i'll take a stab at trying to figure this out myself. I do appreciate the time and suggestions they offered if they're reading this. I used the search feature but still str...
by hidefguy
28 Apr 2017, 19:20
Forum: Ask For Help
Topic: AHK programmer needed
Replies: 1
Views: 424

AHK programmer needed

Hello AHK people. I developed a simple script that uses keystrokes with sleep commands to vary timing. I have very basic coding skills and limited free time. The script functions to test entries/exits in my trading software, then create/save an excel performance report to a windows explorer folder. ...

Go to advanced search