Hi folks,
I'm talking about manipulating the Windows directories/folders/files. Decades ago when I was working with A97 and later A2003, I had to use APIs (http://access.mvps.org/access/index.html was a great resource) to find files, created directories/folders, change file names, copy files, etc.
At the moment, I am putting something together for my own purposes at work to be able to examine hundreds of files named in the convention test1.jpg, test2.jpg, ... test10.jpg, test11.jpg and add one or more leading 0s as necessary so that windows sort works properly. The result would be file names would change to test01.jpg, test02.jpg, ... test10.jpg, test11.jpg.
Before I go hunting through my old code, I'm just wondering if VBA can handle all of this?
Thanks in advance,
--
Tim