-
deleting specified worsheet from code
i am having total of 4 sheets of which sheet 1 & sheet 4 r compulsory
i am using datatable to fill the sheet with data
if dt1.rows.count<>0
-- write data to excel cells
else
oWB1.Application.DisplayAlerts = False
oWB1.Sheets("ABC").Delete
oWB1.Application.DisplayAlerts = True
end if
if dt2.rows.count<>0
-- write data to excel cells
else
oWB1.Application.DisplayAlerts = False
oWB1.Sheets("XYZ").Delete
oWB1.Application.DisplayAlerts = True
end if
i get error when it goes to else part of dt1 ie on the line
oWB1.Sheets("ABC").Delete
but if dt2 count is 0 the else part gets executed sucessfully ie the sheet 3 gets deleted
error
Public member 'Worksheets' on type 'Worksheet' not found
-
The last error is occuring because you don't have a variable defined As Worksheet
What is the error you are getting on oWB1.Sheets("ABC").Delete
Similar Threads
-
Replies: 4
Last Post: 06-02-2008, 07:30 AM
-
By Laurel in forum VB Classic
Replies: 3
Last Post: 02-08-2005, 12:17 PM
-
By anonymous in forum VB Classic
Replies: 4
Last Post: 02-08-2004, 05:58 AM
-
By Ricky in forum VB Classic
Replies: 1
Last Post: 04-20-2000, 08:06 AM
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
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|