Macro - path folder destination

Hello

I have an existing macro that saves my plans in PDF/DXF/DWG. But only in the source folder.

I would like to add some lines to my macro in order to open a window to give the destination path of my exports.

Do you have any solutions please?

Thank you

ATTACHED IS THE EXISTING MACRO


pdf_dxf_dwg.swp

Hello

Attached is the modified version containing a folder exploration function.

You just have to reposition in the right place and finish the processing to concatenate the destination folder and the file name.


pdf_dxf_dwg-explo.swp
2 Likes

Thank you very much, that's exactly it.

Is there a way to have the windows address bar in the window to facilitate the copy of destination paths?

Hello

From memory, not with this way of doing things. On the other hand, it is possible to create a form in which we place a textbox, the result of which is retrieved in this line:

sDossDest = FolderBrowse("Choisir un répertoire à traiter...", TextBox1.Value)