Results 1 to 14 of 14

Thread: How to read .xls file using vb

Hybrid View

  1. Oct 20th, 2008, 10:39 PM #1
    kynn
    kynn is offline
    New Member
    Join Date
    Oct 2008
    Posts
    7

    Re: How to read .xls file using vb

    We want to extract data from certain row/column of excel to text file automatically.
    Example: (row 5: column B)

    We tried alot of methods but we couldnt do it.

    Do you have any idea on how to extract data from Excel to text file automatically?

    Thank you
    Reply With Quote Reply With Quote
  2. Oct 20th, 2008, 10:58 PM #2
    CDRIVE
    CDRIVE is offline
    PowerPoster CDRIVE's Avatar
    Join Date
    Jul 2007
    Posts
    2,620

    Re: How to read .xls file using vb

    Kynn, I have a suspicion that you didn't add a reference to Excel and I also suspect that you didn't create 'Test.xls'. May I suggest that you read the Excel Tutorial here..
    http://www.vbforums.com/showthread.php?t=391665
    It's really the best way to learn VB/Excel.
    <--- Did someone help you? Please rate their post. The little green squares make us feel really smart!
    If topic has been resolved, please pull down the Thread Tools & mark it Resolved.

    Is VB consuming your life, and is that a bad thing??
    Reply With Quote Reply With Quote
  3. Oct 21st, 2008, 02:59 AM #3
    kynn
    kynn is offline
    New Member
    Join Date
    Oct 2008
    Posts
    7

    Re: How to read .xls file using vb

    thank u so much...

    my excel is 2000. I am following the tutorial by adding a references but i couldnt find the references. My excel doesnt have the "project" tab. I search for the references but couldnt find it.
    Reply With Quote Reply With Quote
  4. Oct 21st, 2008, 07:20 AM #4
    CDRIVE
    CDRIVE is offline
    PowerPoster CDRIVE's Avatar
    Join Date
    Jul 2007
    Posts
    2,620

    Re: How to read .xls file using vb

    Quote Originally Posted by kynn
    thank u so much...

    my excel is 2000. I am following the tutorial by adding a references but i couldnt find the references. My excel doesnt have the "project" tab. I search for the references but couldnt find it.
    The Project tab is in Visual Basic, not Excel. Are you using VBA? If you're wondering what VBA is, it's the version of VB that runs behind Excel. If you're accessing VB by running Excel and then accessing VB from Tools/Macros/VB then your using VBA. VBA is not a stand alone version of VB.
    Last edited by CDRIVE; Oct 21st, 2008 at 08:02 AM.
    <--- Did someone help you? Please rate their post. The little green squares make us feel really smart!
    If topic has been resolved, please pull down the Thread Tools & mark it Resolved.

    Is VB consuming your life, and is that a bad thing??
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width