elerium115
Reputation: 21
Workbook.SaveAs() to different folder in Office 2011 for Mac
How to save xls to another folder?
When I use "/" in save path it replaces then with ":". When I try to use "\" it saves the file with "\" in file name.
Upvotes: 0
Views: 1424
Answers (1)
Banjoe
Reputation: 1768
Use the Application.PathSeparator property and as an added bonus it'll be platform agnostic.
myPath = "myDirectory" & Application.PathSeparator & "mySubDirectory" & Application.PathSeparator & "myFileName"
Upvotes: 2
Related Questions
- How can I Save an Excel Workbook in a different location?
- VBA save worksheet as workbook in a specific path
- Save workbook in user specified path
- Trying to save workbook to a folder specified by the user
- Visual Basic: Save in same folder as Excel Sheet
- Saving a newly created workbook to a specific folder
- vb.net how to Save excel Workbook to Specific Folder using Save Dialog Box
- Save excel Workbook in a new created folder with the Same names
- How can I SaveAs a new workbook to original workbook directory with Excel VBA?
- Saving as .xlsx in different directory in vba