VBA ERROR - document not saved

[Ananthak275]

When I run this, the only the first workbook is saved as System. both document and optimization error out that "document not saved 1004"

Set wbk_syst = ActiveWorkbook
ActiveWorkbook.SaveAs "\\Extract\system " & Format(Date, "yyyy-mm-dd") & ".xlsx"

Workbooks.Add
Set wbk_doc = ActiveWorkbook
ActiveWorkbook.SaveAs "\\Extract\documents " & Format(Date, "yyyy-mm-dd") & ".xlsx"

Workbooks.Add
Set wbk_doc = ActiveWorkbook
ActiveWorkbook.SaveAs "\\Extract\optimization " & Format(Date, "yyyy-mm-dd") & ".xlsx"

 

[Joe4]

Duplicate to: Debug: Run time error 1004 - "Method Save_AS Object' _Workbook' Failed

Why did you start a new thread on the question that I am currently helping you on?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.