joeloyzaga Posted May 28, 2014 Posted May 28, 2014 I have this workbook - BiztalkClient280502JOE.xls (call this A) which contains data within multiple worksheets and I want to copy all worksheets into workbook B. If they already exist then don't copy them over. I want to run this from a .vbs so I will need to use parameters (workbookFROM, workbookTO) I guess. I have this code that I have used before to run an exe but I don't know how to run an exe with params... Set oAutoIt = CreateObject("AutoItX3.Control") oAutoIt.Run("C:pwcCriteria-Select.exe")
Moderators JLogan3o13 Posted May 28, 2014 Moderators Posted May 28, 2014 You're asking a vbs question on an AutoIt forum?? If you want to accomplish it with AutoIt, look in the help file under the _Excel functions. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
joeloyzaga Posted May 30, 2014 Author Posted May 30, 2014 No I'm not worried about the vbs - its the worksheet copy I guess I use _ExcelReadSheetToArray from the source sheet and then _ExcelWriteSheetFromArray to destination sheet?
Moderators JLogan3o13 Posted May 30, 2014 Moderators Posted May 30, 2014 (edited) If you look at the updated Excel UDF (link below), there is a function for copying or moving a sheet both within the same workbook and to another - _Excel_SheetCopyMove. '?do=embed' frameborder='0' data-embedContent>> Edited May 30, 2014 by JLogan3o13 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
water Posted May 30, 2014 Posted May 30, 2014 The latest beta version of AutoIt has the most ucrrent version of this rewritten Excel UDF. 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