Common Dialog Question

[fieldling]

I'm using the MkDir function on a command button which creates a new folder in the C: drive. Example:

MkDir "C:\Export Folder"

I'd like to be able to choose the file name and destination this is saved to so need to call the SaveAs dialog box if possible. Any suggestions how to do this?

Thanks

 

[Velid]

To create/delete folder and files and do a bit more with files look for Scripting.FileSystemObject.

I used it to move backup files, create new files and to check if files are already existing.

Although, if you use outputto (docmd.outputto) and don't provide where to output object (table, query or report) then it will prompt you with with 'SaveAs' dialog with default name being the name of the object you're outputing.

Hope this helps.

 

[fieldling]

Have now sorted it. Thanks