|
-
Feb 17th, 2000, 08:51 PM
#1
Thread Starter
New Member
Dear vb users,
When I have started Excel in VB5, I want to change to an other sheet.
Code:
Dim XLsheet As Object
Set XLsheet = GetObject("c:\book.xls")
XLsheet.Application.Visible = True
Worksheets("test").Activate
In the last sentence occurred an error:
Method 'Worksheet' of object '_global' failed
What do I wrong?
Knows someone a other source?
Mary
-
Feb 17th, 2000, 11:03 PM
#2
New Member
you have to add the dollar sign onto the end of a worksheet name so "sheet1$"
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
|