I have the following bit of code that normally works, but lately I'm getting
errors on the SaveAs line. It's completely kicking me out of excel.

aWBname = aWB.Name
aWBname = oWB.Path & "\" & aWBname 'Didn't have this line
originally and it worked
Application.DisplayAlerts = False
aWB.Close savechanges:=False
oWB.SaveAs Filename:=aWBname
Application.DisplayAlerts = True
oWB.Close


Does anyone have any idea why I might be having these problems? Sometimes
it works and sometimes it doesn't.

Thanks,
Barb Reinhardt

It appears that copying worksheets from aWB to oWB caused this problem
somehow. WHen I moved them, I had no error. I believe the workbooks with
issues had links from one sheet to another.

Barb Reinhardt



"Barb Reinhardt" wrote:

I have the following bit of code that normally works, but lately I'm getting
errors on the SaveAs line. It's completely kicking me out of excel.

aWBname = aWB.Name
aWBname = oWB.Path & "\" & aWBname 'Didn't have this line
originally and it worked
Application.DisplayAlerts = False
aWB.Close savechanges:=False
oWB.SaveAs Filename:=aWBname
Application.DisplayAlerts = True
oWB.Close


Does anyone have any idea why I might be having these problems? Sometimes
it works and sometimes it doesn't.

Thanks,
Barb Reinhardt