cscottnelli

Copying multiple spreadsheets into clipboard array

6 posts in this topic

#1 ·  Posted (edited)

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 by cscottnelli
attached file

Share this post


Link to post
Share on other sites



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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

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 by cscottnelli

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Did you have a look at _Excel_RangeCopyPaste?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now