2 Replies - 1465 Views - Last Post: 11 March 2012 - 08:09 PM Rate Topic: -----

#1 vnamekat  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 08-March 12

Read an excel sheet and write csv text file

Posted 08 March 2012 - 07:07 PM

I want to be able read the values in a worksheet and write to a csv text file. How do you refer to the worksheet in VB?
Is This A Good Question/Topic? 0
  • +

Replies To: Read an excel sheet and write csv text file

#2 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 303
  • View blog
  • Posts: 1,796
  • Joined: 26-March 09

Re: Read an excel sheet and write csv text file

Posted 09 March 2012 - 01:03 AM

If you look to your right, there is a tutorial about using Excel with VB6, which is probably a good starting point.
Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Read an excel sheet and write csv text file

Posted 11 March 2012 - 08:09 PM

Alternatively, you can simply save the excel file as a csv file directly.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1