Copying multiple spreadsheets into clipboard array

[cscottnelli]

Hello.

I am working with multiple spreadsheets that I'd like to export and combine into a master file. The source spreadsheets are located on a virtual machine, so I have to use a script to copy each spreadsheet into the clipboard and then paste it into the master spreadsheet on my local machine.

What I think is a better way, and I'm trying to figure out, is how to read the clipboard contents of each spreadsheet I copy into an array, and then paste the entire array into the master spreadsheet at once. I'm still very new to autoit, and I have so far automated the opening and copying of each spreadsheet into the clipboard, but I can't exactly figure out how to setup the array properly and append the data into the array so that I can paste everything into the master file. Any help would be greatly appreciated. I attached the script I am using now. Let me know if I should provide any more info. Thank you!

 

autoit_script.txt

Edited September 15, 2017 by cscottnelli
attached file

[water]

You could create and use a shared folder between your physical and virtual machine. Then it is quite easy by using the Excel UDF that comes with AutoIt to create the needed master workbook.

[cscottnelli]

Thank you for your reply. Unfortunately I do not have access to any of the configurations on the virtual machine, and can't setup a shared folder. :-(

Edited September 16, 2017 by cscottnelli

[water]

But if the powers that be have configured a shared clipboard I would try to convince them to configure a shared drive as well.

[cscottnelli]

I'm sorry but this is not an option. Autoit is an option and that is why I am posting here. If you have anything to add in regards to using autoit I would appreciate it, thank you!

[water]

Did you have a look at _Excel_RangeCopyPaste?