Export file to specified folder 📂in a path, but if folder does not exist save file to "TEMPFolder"

[Datament]

Hello, I have a situation whereby when I click btn_Finished I need to export "Statement_file" to one of the existing subfolders with "USERS" names "fld_Abi", "fld_Clint", "fld_Dell", "fld_Many", "fld_More" and "fld_TEMPFolder"(Not assigned to any user). All the subfolders are in a folder "FLD_ReportPickup" and are all named after each user except the "fld_TEMPFolder" which is to be used only when a user name is not setup or does not exist in the folder "FLD_ReportPickup".



This is what I currently have:

Dim User As String
Dim TempDAPath
Dim DAPath

If User = "" Or IsNull(User) Then
User = "fld_TEMPFolder"

DAPath = "W:\Service Center\Reports\Dealerships\DealershipsONLY\Processors" (Statement_file is correctly autosaved here in the "Processors" subfolder)

TempDAPath = "W:\Service Center\Reports\Dealerships\DealershipsONLY\Process ors\FLD_ReportPickup" & User & "
(Statement_file is NOT saving in any user's subfolder or in the "fld_TempFolder")

Please correct me, what am I doing wrong? I need the btn_Finished to save Statement_File to respective USER's subfolder, and in the case of a new user that has not been setup, or a subfolder that does not exist saved in "fld_TEMPFolder".

End If

[moke123]

Take a look at FSO and all the methods associated with it. https://learn.microsoft.com/en-us/of...mobject-object

You could just test if a folder exists for a user and if not, create it, and then save the file to it.

[June7]

If Dir(TempDAPath) = "" Then MkDir TempDAPath (or whatever action you want to take)

Assumes every folder above User folder already exists.

Is FLD_ReportPickup supposed to be a folder above user folder?

[Datament]

Thanks for your response and question:

Is FLD_ReportPickup supposed to be a folder above user folder? YES
W:\Service Center\Reports\Dealerships\DealershipsONLY\Process ors\FLD_ReportPickup\fld__Abi, fld_Clint, fld_TempFolder.......

And fld_TempFolder already exists in the fld_ReportPickup folder for the purpose of saving files by users not yet set up. So, there wouldn't be a need to create another folder but to detour the file to fld_TEMPFolder when a new user's folder is not found.

Again THANKS for your assistance

[June7]

Did you try If Then statement I suggested?

Why not create folder instead of saving to temp folder?