VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 267
- Office Version
- 365
- Platform
- Windows
- MacOS
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.
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.
