The below code is not working in BP. Can anyone help? it shows "Not delared/Not memeber" errors. Do i need to add any namespace.
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open ("U:\XXXX")
objExcel.Visible = True
objWorkbook.Worksheets("XXSheetnameXX").Range("A1:A25").Copy
Set objWorkSheet = objWorkbook.Sheets.Add
objWorkBook.Worksheets("Sheet1").Range("A1").PasteSpecial -4163
objWorkBook.Worksheets("Sheet1").Range("C1").PasteSpecial -4163
objWorkBook.Worksheets("Sheet1").Range("B2:B25").Value = "0"
objWorkBook.Worksheets("Sheet1").Range("B1").Value = "BBB"
objWorkBook.Worksheets("Sheet1").Range("C1").Value = "CCC"
objWorkbook.Worksheets("Sheet1").Activate
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open ("U:\XXXX")
objExcel.Visible = True
objWorkbook.Worksheets("XXSheetnameXX").Range("A1:A25").Copy
Set objWorkSheet = objWorkbook.Sheets.Add
objWorkBook.Worksheets("Sheet1").Range("A1").PasteSpecial -4163
objWorkBook.Worksheets("Sheet1").Range("C1").PasteSpecial -4163
objWorkBook.Worksheets("Sheet1").Range("B2:B25").Value = "0"
objWorkBook.Worksheets("Sheet1").Range("B1").Value = "BBB"
objWorkBook.Worksheets("Sheet1").Range("C1").Value = "CCC"
objWorkbook.Worksheets("Sheet1").Activate