Results 1 to 40 of 48

Thread: open excel worksheet in vb.net

Hybrid View

  1. Mar 20th, 2006, 12:31 PM #1
    bgard68
    bgard68 is offline
    Addicted Member bgard68's Avatar
    Join Date
    Mar 2006
    Location
    Arkansas
    Posts
    164

    Re: open excel worksheet in vb.net

    Do you have 4 worksheets or 3 worksheets?

    If you have 3 worksheets then try:
    'Zero based!
    oWorkSheet = oWorkBook.Worksheets(2)
    Using Framework 1.1, VB.Net 2003 unless I
    state otherwise
    Reply With Quote Reply With Quote
  2. Mar 20th, 2006, 12:34 PM #2
    mike7510uk
    mike7510uk is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2006
    Posts
    22

    Re: open excel worksheet in vb.net

    i have 6 worksheets, i can get Excel to open if i leave out the.....

    'oWorkSheet = oWorkBook.Worksheets(3)
    'oWorkSheet.Activate()


    ....code. Just cant go to the sheet i want. ( I have six sheets and six buttons, each button should open up the correct sheet)
    Reply With Quote Reply With Quote
  3. Mar 20th, 2006, 12:35 PM #3
    mike7510uk
    mike7510uk is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2006
    Posts
    22

    Re: open excel worksheet in vb.net

    I am running 2003 version
    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