creating hyperlink to a file created earlier in the macro

[bradleigh97]

Hello all,

Very new to Excel VBA so please bare that in mind. I've managed to piece together a macro by taking bits from websites / other forums which is why it may be a little clunky, but I can't seem to find what I'm looking for. Below is my very sub-par code. Essentially I am creating a new file from an existing workbook and then creating an email with which a link to this file is included. At the minute I have managed to link to the folder that the file is saved in, but I cannot link it to that specific file that has been created earlier in the macro. This is the line I am talking about, full code is in the attached file. In the file it is refering to Macro "New_doc_save"

" <a href=""G:\Manufacturing\Quality\Internal_Defect_Log\IDL_Investigations"">IDL Investigation Document</a>

Any help would be appreciated - as I mentioned I am a complete novice so I appreciate the code could probably be simplified / improved. Any feedback is appreciated, cheers Brad

[jdelano]

Give this a try:

Please Login or Register  to view this content.

edit: added a couple comments

[ByteMarks]

Use file:// when using href to link to a file.

Please Login or Register  to view this content.

[bradleigh97]

Hi, works perfectly thank you so much!

[ByteMarks]

You're welcome. Thanks for the feedback.