View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Saveas Error (attempt 2)

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