Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opened excel file from email & clicked save after modify . Where i bravorimes Excel Discussion (Misc queries) 2 July 27th 08 06:45 PM
Using Excel Interop via VS.NET 2005 to create and save a new Excelworksheet.. please help! [email protected] Excel Programming 0 January 18th 08 06:39 PM
how to save an Excel 2007 on CD, be able to open it using 2005 doinginventory Excel Discussion (Misc queries) 4 January 15th 08 06:08 PM
Trying to open Excel From Visual Basic 2005 [email protected] Excel Worksheet Functions 1 March 22nd 07 03:44 AM
How to save excel spreadsheet and word doc with one save CEP Excel Programming 0 April 29th 05 10:29 PM


All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"