User input to select file and save copy in hidden folder

[RichTea88]

Good Morning Guys.

Before posing my question properly I'd just like to say thanks to everyone on here who's helped me. I've been part of this forum around a year now and had help from here countless times, I've learnt a lot from you guys and I really appreciate it.

I've set up an excel workbook to help me with document control. One of this things I'd like to add to this workbook is a way to select a file and have it save that file under a specific name in a hidden folder. Each document that is created has a worksheet where I keep the details - See attached picture. Step by step this is what I'd like to be able to do.
1. Click a button (to be added to the template)
2. prompt the user to select the document - file
3. prompt the user to select final or native
3. save that file to a hidden folder(final or native) in a set location naming the file using the 'Document Number'_'Current Revision'
4. create a hyperlink to that file in either the document revisions (final) section or the Native Files section

It's really the user input that I'd struggle with, and is it possible to save a file to a hidden folder this way? the files types would be pdf and doc files.

Any help would be fantastic, rep for help as always.

Thanks,

R

[RichTea88]

Sub getFile()
Application.Dialogs(xlDialogOpen).Show
End Sub

Found this code, which brings up the file browser that I'd like. But this opens the file you select. I'd like it save a copy of the selected file in pre-defined location(hidden folder) and save it with a predetermined name

Any ideas guys?

[RichTea88]

maybe I could do this another way? Have the person select the file, save the file extension in a certain cell then use that somehow to make a copy of the file and save it using the 'Document Number'_'Current Revision' in the hidden folder?

Anyone have any suggestions at all? I'll accept bad ones too so long as it gets the brain juices flowing!

[RichTea88]

Okay.

Can I use this code

Please Login or Register  to view this content.

to get the person to open the wordfile then use this in the same macro

Please Login or Register  to view this content.

Where File Path is a predetermined folder pather, DocNo is taken from 'B7' and RevNo is taken from 'M4'

Would that work? because all the code would be in excel but I would have just activated a word document?

[RichTea88]

Never mind guys,

I managed to get something working.