I'm trying to write some code in VB.NET 2005 to write data to Excel using OLEDB, and VB.NET 2005. Specifically I need to be able to:
a) Write data to an Excel spreadsheet to a single cell defined named range (i.e. the named range called "CustomerName")
b) Write data to a specific cell within a named range (i.e. Row(0).Column(4) within named range "Orders")
c) To be able to defined a range within Excel (ie. Sheet1 A1:F100 = "Orders")
There is some urgency so I'm generous with the points. Good luck!