Copying One Excel Worksheet to Another Excel Spreadsheet file
I have two excel files. BookA.xls and BookB.csv. I would like to copy the entire sheet "Projects" which is in BookA.xls over to a new sheet in BookB.csv (which already exists and contains data on other sheets) by using VBScript.
.. one other thing, the sheet "Projects" is dynamic and therefore using the Range.Copy as an option isnt really possible since one day this sheet could be 100 rows long or 10000 rows long etc etc