Excel VBA SaveAs function within Box

Hello all, I have been using Excel VBA within box for about 4yrs now and a script that I have used in the past just stopped working 2 days ago. I am essentially using a .xlsm file as a working file and creating a data tab and then making a copy of that data tab and saving it as a stand alone file and making the format .xslx which has worked for years now and 2 days ago I am starting to get an error running this code which results in a Error 1004 SaveAs"Method Saveas of object workbook failed" but if I move the file to my desktop runs with no issues? Not sure what could be causing this but I am stuck until it is resolved.

Here is the script in case anyone wants to see what is happening. FYI - This is being done on a Mac computer.

Sub Create_Upload()

Dim RelativePath As String, DT As String, WbNam As String, ws1 As Worksheet

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Set ws1 = Sheets("Actuals Data")

RelativePath = ThisWorkbook.Path & "/"
DT = Format(CStr(Now), "mm_dd_yyyy hh.mmam/pm")
WbNam = "Submission Template " & " - " & DT 'Creates the File Name

ws1.Copy 'Copies the entire sheet into a new workbook
ActiveWorkbook.SaveAs fileName:=RelativePath & WbNam & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWorkbook.Close Save

MsgBox "Submission file saved to the folder where this tool resides."

Application.ScreenUpdating = True
Application.DisplayAlerts = True

End Sub

Rona

July 27, 2023 20:49
Edited

Hi Jonathan,

Welcome to Box Community and glad to help!

You may reach out to your internal helpdesk for assistance. That way they could contact us instead and create case if necessary.

Thanks for posting!

Scott Sullivan

July 31, 2023 19:58

Hi Jonathan, I have the same issue saving a new file to Box and iCloud folders in my Excel VBA code. Did you get a resolution from your internal helpdesk? Thanks...

Jonathan Lee

July 31, 2023 22:22

Hi Scott, unfortunetely I opened a ticket with my companies help desk but other than that no other action yet. Hoping to have some sort of resolution. For the meantime the workaround has been to save the file to the desktop and run my file there since saving a new file to the desktop does not cause the issue.

Johnny Thunder

December 07, 2023 22:18

So, still no resolution on this. Our internal help desk is looking into it and has already opened a case with the Box Support Team but nothing to this point has been fixed. There has been a new Software update for MacOS, Box and Excel but this same issue is present across all 3 platforms.

Comments