Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opened excel file from email & clicked save after modify . Where i | Excel Discussion (Misc queries) | |||
Using Excel Interop via VS.NET 2005 to create and save a new Excelworksheet.. please help! | Excel Programming | |||
how to save an Excel 2007 on CD, be able to open it using 2005 | Excel Discussion (Misc queries) | |||
Trying to open Excel From Visual Basic 2005 | Excel Worksheet Functions | |||
How to save excel spreadsheet and word doc with one save | Excel Programming |