creating folders one level down

  • Thread starter Thread starter Anders
  • Start date Start date
A

Anders

Hi All,

using RDB code to create a subfolder and save a copy in it.

'Create new folder to save the new files in
DateString = Format(Now, "yyyy-mm-dd hh-mm-ss")
FolderName = Sourcewb.Path & "\" & Sourcewb.Name & " " & DateString
MkDir FolderName

Example: saving file 'FTE' in folder 'Update'. This would create subfolders
with timestamp each time I saved it (folder update then would have hundreds
of files in it). I would like to redirect that folder creation to one level
down in a folder named 'archives' (already created) so archives has all of
the files in it and update only has two items. 1. the file FTE, 2. folder
archives.

TIA.

Anders
 
Back
Top