Output to new folder

mikirkeby

Hi,

I have an issue with some backups. I'm reading a bunch of tables from a datebase, appending a prefix with a date stamp, and saving them individually as .csv files. Since the flow with these backups is to be run weekly, I would like it to automatically create a new folder with the date as the file name, and output the individual .csv backup files inside this folder.

Is this possible?

SeanAdams

Here you go Michael,

Stripped this down to the bare bones to demonstrate the concept.  Note - this relies on you having a folder on your c:\ called Temp, but you should be able to amend as you need.

Thank you for following up with me - hopefully this solves your problem.

I would suspect that if you need to create some directories, then write a bunch of files, you'll need to wrap this in a macro.   If that's the case - shoot over some sample data, and we can take the next step of showing you how to do both the folder creation, and then also writing the data into the files in the subfolder.

Cheers

Sean

Make Directories.yxmd