![]() ![]() ![]() The initial destination path for the folder to be placed in will always remain the same.įilename: 2021.02.11 - A123ABC - Report Type 1 The filename would be the same as the folder name but with "Report Type 1", "Report Type 2" or "Report Type 3" after the TxtVRM data depending which of the three drag/drop zones the file was dropped in to. in the place of a / ) and then the value from TxtVRM textbox, each separated by " - ". Then when I click the CmdAdd command button, as well as submitting the data entered on the form into my spreadsheet, it also creates a new folder using the TxtDate textbox (but reversing the date and placing a. What I basically want is to drag a file into one of three drag/drop zones on UserForm UFAddEntry, depending on what the file is. Is it possible to drag & drop a file from an e-mail (Microsoft Outlook if that matters) onto a UserForm and then save the file in a new folder with the folder and filename created from data inputted in other fields in the UserForm?
0 Comments
Leave a Reply. |