驗證網址www.techonthenet.com安全性

MS Excel: How to use the DIR Function (VBA)

Question: I'm not sure if a particular directory exists already. If it doesn't exist, I'd like to create it using VBA code. How can I do this? Answer: You can test to see if a directory exists using the VBA code below: If Len(Dir("c:\TOTN\Excel ...

網址安全性掃描由 google 提供