I am attaching the excel file and below is the code
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False
Set wrk = oExcel.Workbooks.Open(sPath)
Set sht = wrk.Sheets
For each sheet in sht
No idea why i get the runtime error only for this sheet and it works for others, and i am really going mad at this...what seems to work today does not work the next day...
I cant create new file everyday for this.
Getting Application-defined or object-defined error for the Second statement above, but works fine for the other two.
In a way i am not able to retrieve the first sheet name but retrieve others..no idea why..