Close Workbook after it was opened by task scheduler

[ac3100]

I have a workbook that I open with the task scheduler.

I don't want to use any code to close itself.

So that means that I want to save and close it using another workbook.

How can I aceive this?

 

[kpark91]

I'm not too sure what you mean that not wanting to use any code to close itself.

Why don't you just delete the
Workbook.Close command from the workbook code?

 

[ac3100]

I guess that wasn't too clear.

The workbook that gets opened by the task scheduler performs a data refresh.

After the first workbook is opened, I want to open a second workbook to save and close it.

 

[ac3100]

This appears to work:
Dim WB As Workbook

For Each WB In Workbooks
If WB.Name = "Account Advanced Find View.xlsx" Then WB.Close SaveChanges:=True
Next

Under a different method I was getting a subscript out of range error.

 

[ac3100]

Actually that did not work because the second file opens up a separate instance of Excel. This is very frustrating!