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.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
Use the Application.PathSeparator property and as an added bonus it'll be platform agnostic.
myPath = "myDirectory" & Application.PathSeparator & "mySubDirectory" & Application.PathSeparator & "myFileName"
