Copy from Excel cell, and paste into a Mainframe session
Using Foxtrot 11.1 and Office 365 Enterprise
I am trying to copy a numerical value from an Excel cell (let's say A1), and paste them into a specific location in a Mainframe session. There are established connections between the Foxtrot and the Mainframe session, and also to the Excel file. Is there anyway to just copy the value to the clipboard? I have tried to use every Excel copy feature and none of them seems to just get it to the clipboard. I keep getting errors that there needs to be a target, but there is nothing. Just the error.
The process should be simple; copy contents of Excel cell A1 and paste to cursor position in the Mainframe window. But it's not.
Any ideas?
The ultimate goal is to create a loop so that it functions like:
Loop 1 to 10
Copies the number Excel cell A[loop#]
Paste to specific Mainframe location, [@Enter]
Screen capture and save to file as Image[loop#].jpg
Next Loop
Result is 10 images saved Image1.jpg, Image2.jpg... Image10.jpg
Ideas?
-
You might find it useful to update to a newer version of Foxtrot, possible from the following link: https://support.foxtrotalliance.com/hc/en-us/categories/115000317371-Download-Foxtrot.
To answer your question: Yes, you can copy to the clipboard value. After you have copied the value from Excel using the Copy Cell action, the value will be saved in the clipboard. Hence, to paste the value in the Mainframe session you should use the [*WINDOWS_CLIPBOARD_VALUE] expression as showed below.
Note that it might be useful to clear the clipboard before you copy the value from excel, by using the “Clear Clipboard” action under the Computer pane.
Alternatively, the ”Get Value” action could be used to retrieve the value from Excel and save it directly to a variable.
Below you can see the two different solutions, separated by a line:
Please sign in to leave a comment.
Comments
1 comment