View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MaxGruven MaxGruven is offline
external usenet poster
 
Posts: 2
Default VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it

I have the following requirement:

From a VB.NET Windows Form Application developed in VS.Net 2005, I need to
be able to customize an Excel Spreadsheet for a user of the program based
upon some choices made.

The Excel Spreadsheet has 3 headers rows (merged columns) across the top and
they never change. The 4th row is column headings for all the subsequent
rows which can be filled in with data.

The users may have Excel 2002, Excel 2003 or even Excel 2007 on their
machine. (I think this is the hard part. Our users can have one of 3
versions of Excel on their machines)

Is there a way, from VB.NET to open up our master Excel spreadsheet stored
on the users machine, remove columns that they dont need and then write out
the modified spreadsheet to their My Documents folder?

TIA,
Max