Non-invocable member 'Microsoft.Office.Interop.Excel._Workbook.Worksheets' cannot be used like a method is a common error for a VB programmer working on C# projects. The error is solved when the round brackets are replaced with square ones
Excel.Worksheet oWS = (Excel.Worksheet)oWB.Worksheets(1);
To
Excel.Worksheet oWS = (Excel.Worksheet)oWB.Worksheets[1];
Error Message
Thank you, that stopped me banging my head against the wall....
ReplyDelete