hyperlink error on saving

[nighttrainrex]

Hi All,

I have a macro that when run, copies a master sheet, opens a new workbook pastes the copied data, saves & re names the new worksheet & workbook and adds information to a register in the 1st workbook with a hyperlink to the new workbook.

The problem I cant get passed is the hyperlink will only open the folder my new workbook is saved in not the file (obviously I have not got it quite right), I have tried for about 3 days to get it to work looking at other posts here & I can get it to work if I save as a PDF type file but not as an excel type..

I need to be able to bring up the new workbook to add new orders to it from time to time.

Thanks for looking Rex.

Draft Sealing Agg Reg 1.xlsm