3 Replies - 2169 Views - Last Post: 15 August 2006 - 11:13 AM Rate Topic: -----

#1 the_hangman  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 602
  • Joined: 18-January 06

Editing excel spreadsheets with VB.NET

Posted 02 August 2006 - 07:23 AM

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?
Is This A Good Question/Topic? 0
  • +

Replies To: Editing excel spreadsheets with VB.NET

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,506
  • Joined: 12-July 02

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?
Was This Post Helpful? 0
  • +
  • -

#3 the_hangman  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 602
  • Joined: 18-January 06

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...
Was This Post Helpful? 0
  • +
  • -

#4 the_hangman  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 14
  • View blog
  • Posts: 602
  • Joined: 18-January 06

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.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1