Use value from excel in VB .Net

Use changing excel value as variable in VB .NET

Page 1 of 1

1 Replies - 2851 Views - Last Post: 01 April 2009 - 08:54 AM Rate Topic: -----

#1 mmiller039  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 30-March 09

Use value from excel in VB .Net

Post icon  Posted 01 April 2009 - 08:02 AM

I wanted to find out if it was pssible to use a cell in excel that has data in it that is constantly being updated (by time, variations in user input, etc), whether I can link this cell with VB .NET so that the program will run holding the cell and record the data every 50ms in a database. So in simple terms link the excel cell to the VB .NET program real-time. Cannot seem to find any info on this anywhere.
Thanks
Is This A Good Question/Topic? 0
  • +

Replies To: Use value from excel in VB .Net

#2 Bort  Icon User is offline

  • Ill-informed Mongoloid
  • member icon

Reputation: 413
  • View blog
  • Posts: 3,023
  • Joined: 18-September 06

Re: Use value from excel in VB .Net

Posted 01 April 2009 - 08:54 AM

This should be doable.

Check out my Office Automation tutorial for info on getting details from Excel into your VB projects. Then just put that on a timer to update it every half second or so.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1