could you help me what is wrong in it? thanks
accounts is the sheet name
i have error obejct required in x1_wb.sheets(Accounts)
Set xl_wb = xl.Workbooks.Open(sFile)
x1_wb.sheets(Accounts).Range("A:D").EntireRow.Font.Size = 10
Printable View
could you help me what is wrong in it? thanks
accounts is the sheet name
i have error obejct required in x1_wb.sheets(Accounts)
Set xl_wb = xl.Workbooks.Open(sFile)
x1_wb.sheets(Accounts).Range("A:D").EntireRow.Font.Size = 10
Code:x1_wb.sheets("Accounts")