cscottnelli Posted September 15, 2017 Posted September 15, 2017 (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 September 15, 2017 by cscottnelli attached file
water Posted September 15, 2017 Posted September 15, 2017 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
cscottnelli Posted September 16, 2017 Author Posted September 16, 2017 (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 September 16, 2017 by cscottnelli
water Posted September 16, 2017 Posted September 16, 2017 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
cscottnelli Posted September 17, 2017 Author Posted September 17, 2017 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 Posted September 17, 2017 Posted September 17, 2017 Did you have a look at _Excel_RangeCopyPaste? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now