abenitez77
Registered User.
- Local time
- Today, 16:16
- Joined
- Apr 29, 2010
- Messages
- 141
I have a process that runs thru thousands of files and in the end of several steps it saves the file to the z drive. I ran into a problem when it tried to save a file that has a ? in the name. I converted that to chinese letters.
When I check z drive the file it created was :
Vango loveseat 产品资料FR091 20171205.xls
How did this happen and how do I prevent this?
Code:
ProWkBk = "Vango loveseat ????FR091 20171205.xls"
ActiveWorkbook.SaveAs "Z:" & ProWkBk
Vango loveseat 产品资料FR091 20171205.xls
How did this happen and how do I prevent this?