Question: how to copy data from one workbook to another workbook using vbscript?
Answer: Set objWorkbook = objExcel.Workbooks.Open(“c:\Scripts\Test.xls”) Set objWorksheet = objWorkbook.Worksheets(“Sheet1”)
Set objRange = objWorksheet.Range(“A1:A20”) objRange.Copy.
Set objExcel2 = CreateObject(“Excel.Application”) objExcel2.Visible = True.
Set objWorkbook2 = objExcel2.Workbooks.Add.