copy all worksheets from workbook A to B

[joeloyzaga]

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")

[JLogan3o13]

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.

[joeloyzaga]

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?

[JLogan3o13]

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

[water]

The latest beta version of AutoIt has the most ucrrent version of this rewritten Excel UDF.