|
-
Mar 20th, 2006, 12:31 PM
#1
Addicted Member
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 
-
Mar 20th, 2006, 12:34 PM
#2
Thread Starter
Junior Member
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)
-
Mar 20th, 2006, 12:35 PM
#3
Thread Starter
Junior Member
Re: open excel worksheet in vb.net
I am running 2003 version
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
|