|
-
Jun 4th, 2004, 03:15 PM
#1
Thread Starter
Addicted Member
Excel Stays In Task Manager
Why does Excel insist on staying in my task manager?
This Does Work!
For j = 1 To 5
xlApp.Workbooks(LastMonthReport).Worksheets("Week" & j).Select
Set Wsheet = xlApp.Workbooks(LastMonthReport).Worksheets("Week" & j)
Wsheet.Range("D1").Value = ""
Set Wsheet = Nothing
xlApp.Quit
Set xlApp = Nothing
Wsheet.Range("F3", cells(DeleteRow, 6)).Value = ""
Next j
This Doesn't Work!
For j = 1 To 5
xlApp.Workbooks(LastMonthReport).Worksheets("Week" & j).Select
Set Wsheet = xlApp.Workbooks(LastMonthReport).Worksheets("Week" & j)
Wsheet.Range("D1").Value = ""
Wsheet.Range("F3", cells(DeleteRow, 6)).Value = ""
Set Wsheet = Nothing
xlApp.Quit
Set xlApp = Nothing
Next j
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
|