Vba Auto Increment File Name Too Long To Delete
During this webinar you'll see how much time will be saved using our BIM applications for timber framing in AutodeskĀ® RevitĀ®. Main themes: - make wooden roof framing using common rafters, hip/valley rafters, collar beams, ridges, girders, sleepers, trimmers etc.; - generate wooden truss systems for the roof; - make wooden wall frames including studs, plates, openings, bracings, noggins and other supporting frames with ease; - create a log house; - update frames with custom settings; - renumber frames automatically; - make shop drawings of created trusses, wall frames or separate beams; - export wooden frames and trusses to AutodeskĀ® Robot.
20170125.txt // first file create on the day. 20170125-01.txt // 2nd file 20170125-02.txt // 3rd file So far I've got this super basic script that creates my first daily file but I'm stumped as to how to do the incremental numbering after that.
I am looking for VBA to add to my macro that will increment the file name if the file name already exists.
Current Code:
Vba Auto Increment File Name Too Long To Delete Windows
An example of the saved file name would be 'TD101401.600'. TD + MMDD + 01 + .XXX. I would like the '+ 01 ' to be the number that increments, that way I could have a file that is 'TD101402.600' and so forth. Currently if the file exists for the same .XXX number and date combo, it gets overwritten. The .XXX cannot be the increment.
Is this possible?
pnuts