edit existing excel

  • Thread starter Thread starter glenn.ward
  • Start date Start date
G

glenn.ward

Hello

I have existing Excel files complete with formulas, formatting and
some with macros. I was wondering if VB.Net would allow me to edit an
existing Excel file. I know I can recreate such a file from scratch,
however it would be great to use what is already formatted and has
formulas in place. Far less work. Is this possible to do? If so,
how??

Thanks
Glenn
 
You're going to be looking at theExcelInterop code.  Just reference
the COM libraryExcel11.0 and you can editExcelspreadsheets.

That being said, I would stay away from this unless you have some
requirement to do so.  TheExcelInterop is rough to use and somewhat
fickle in what you can and cannot do.  However it does give you a good
deal of power to specifically edit your spreadsheets.
Click to expand...

Thanks! I have this in my code, however I will do some further
investigation
on this. I know about building a new Excel file, however editing an
existing
one is new to me.
 
Back
Top