Philnblanks
New Member
- Joined
- Aug 22, 2019
- Messages
- 4
I working on a mac and cannot get SaveCopyAs where the path name name has 2 spaces in it.
BTW: I have successfully tested this with a pathname with NO spaces. NOTES: I am running this on a Mac using Excel 365.
Here is my code:
I have tried the following alternatives:
"""/Users/phild/Dropbox (SGPS Showrig)/DDocuments/Test.xlsm"""
'And
"/Users/phild/Dropbox\ (SGPS\ Showrig)/DDocuments/Test.xlsm"
Can someone help me?
BTW: I have successfully tested this with a pathname with NO spaces. NOTES: I am running this on a Mac using Excel 365.
Here is my code:
VBA Code:
Sub MySaveCopyAs()
ActiveWorkbook.SaveCopyAs FileName:="/Users/phild/Dropbox (SGPS Showrig)/DDocuments/Test.xlsm"
End Sub
I have tried the following alternatives:
"""/Users/phild/Dropbox (SGPS Showrig)/DDocuments/Test.xlsm"""
'And
"/Users/phild/Dropbox\ (SGPS\ Showrig)/DDocuments/Test.xlsm"
Can someone help me?