Join our community to see this answer! Unlock 1 Answer and 5 Comments. Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial.
What do I get with a subscription? With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. We can't always guarantee that the perfect solution to your specific problem will be waiting for you.
If you ask your own question - our Certified Experts will team up with you to help you get the answers you need. Who are the certified experts? How quickly will I get my solution? We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.
FSO multiple wildcards for folder path Ask Question. Asked 1 year, 10 months ago. Active 1 year, 10 months ago. Viewed times. Sheets "Sheet3". Improve this question. Wesley Wesley 8 8 bronze badges. But, yes, when you use a string in order to look for. I am afraid you cannot avoid iteration and it would be better I thing to use If InStr "folderName", "5.
Add a comment. Active Oldest Votes. Add ' set Sheets "your sheets's name. Offset 1. Range "a2". Improve this answer. Lee Dy. Lee 7, 1 1 gold badge 9 9 silver badges 14 14 bronze badges. Thanks for the code. I cant get it to work. If I delete this sub, there are errors on the object scripting lines so I changed them to CreateObject "Scripting. FileSystemObject" Then I get errors on the 'dim as folders, same compile error.
Wesley, reference check, Microsoft Scripting Runtime. It was unchecked, If I now change it to the original code it will not give an error but doesn't copy the folders — Wesley.
Default is RecycleOption. The showUI and recycle parameters are not supported in applications that are not user interactive, such as Windows Services. Specifies whether or not an exception is thrown when the user cancels the operation.
Default is UICancelOption. The user cancelled the operation and onUserCancel is set to ThrowException. The showUI , recycle , and onUserCancel parameters are not supported in applications that are not user interactive, such as Windows Services. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.
Contents Exit focus mode.
0コメント