So double quotation is a No,No for my intention?

Cool. Wouldn’t it be:

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

Percent after (“A2”)?

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

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?

@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.

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...

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...

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 ...

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...

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(...

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...

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...

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...

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)....

Thanks again FG. I'll play around with it

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...

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. ...