How to browse file directory to select folder and same for files in word format *.docx

[jk51]

Hi,

See file attached on bookmarks. Need help to correct my VBA coding how to browse file directory and select file using VBA. On cell C3 select cell or click button and it should open new window browse file directory and select folder and the same for cell C5 select file name under the folder save as *.docx for word document to save as (Path and name).

Thank you.

Mr Singh

Location CELL C3: C:\gis\bookmarks\
Template document template.docx
Document to save as (Path and name)
CELL C5: C:\gis\bookmarks\output.docx

 

[PCosta87]

Hi,

Please take a look at the following:
http://forum.chandoo.org/threads/ho...-and-run-merge-multisheets.33111/#post-196329

Look for the "GetFolder" (#2 post) and "GetFile" (#8 post) functions.
It should be pretty straightforward but let me know if you have any questions.

Hope this helps