VBA Issue with Runtime Error

[VBA learner ITG]

Hi all,

I was wondering if i could get your advice, with the below error message and how can i go about fixing this issue on my Mac. I have searched high and low for a mac solution to a fix.

this is the code thats failing:

ExportWorkbook.SaveCopyAs ThisWorkbook.Path & Application.PathSeparator & aGradeData(iGradeRow, 2) & "_" & Format(Now(), "ddmmyyyy_hhmm") & ".xlsx"

erro message

Run-time error '1004':


Microsoft Excel cannot access the file '/Users/zackcarter/Desktop/Dunelm/Birmingham_09082017_1254.xlsx'.There are several possible reasons:


• The file name or path name does not exist.
• The file you're trying to open is being used by another program. Close the document in the other program, and try again.
• The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name.

 

[VBA learner ITG]

Hi all the issue hs been fixed by updating excel with the latest update.

SORRY TO WASTE EVERYONE TIME.