I am trying to do some simple (or i would think they were simple) things with an excel spreadsheet with a VB.NET application. I basically just need to find the value of a cell, then add 1 to it. But I can't figure it out how to do it, or find anything help
got anything for me to read?
Editing excel spreadsheets with VB.NETi need a tutorial
Page 1 of 1
3 Replies - 1939 Views - Last Post: 15 August 2006 - 11:13 AM
Replies To: Editing excel spreadsheets with VB.NET
#2
Re: Editing excel spreadsheets with VB.NET
Posted 02 August 2006 - 07:37 AM
Is it opening the file that you are having problems with, or accessing individual data fields?
#3
Re: Editing excel spreadsheets with VB.NET
Posted 02 August 2006 - 07:47 AM
Um... I'm using that active x spreadsheet thing that you told me about before. I'm not really trying to open a file.
Here is what I'm trying to make. I want to be able to be able to print a variable amount of copies of a spreadsheet, and for each copy the number in cell A1 is incrimented +1 (For PO#'s that can't all be the same)
I'm pretty much stumped on how to do this, so i'm sticking my weinee out in the dark and seeing if I can figure out a way to do it. This was my first idea...
Here is what I'm trying to make. I want to be able to be able to print a variable amount of copies of a spreadsheet, and for each copy the number in cell A1 is incrimented +1 (For PO#'s that can't all be the same)
I'm pretty much stumped on how to do this, so i'm sticking my weinee out in the dark and seeing if I can figure out a way to do it. This was my first idea...
#4
Re: Editing excel spreadsheets with VB.NET
Posted 15 August 2006 - 11:13 AM
I ended up just writing a macro in Excel with the VBA thing Excel has. It works pretty nice.
Page 1 of 1
|
|

New Topic/Question
Reply




MultiQuote



|