Message 1 of 5
Can't obtain Sheet object in Apprentice 2011 in VB6 app
Not applicable
01-28-2011
01:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
According to Intellisense the Sheets collection has an Item method but when I execute this code it say the object does not support this method. Also, notice how "item" is in lowercase. I type upper case but as soon as I move the cursor to another line it reverts back to lower case, why? I can get the Count property of Sheets but not Item, why?
Dim oApprenticeServerDrawingDocument As ApprenticeServerDrawingDocument
Dim oSheet As Sheet
...
Set oSheet = oApprenticeServerDrawingDocument.Sheets.item(1)