Hello.
I'm not having any luck here, I am trying to have the code below enter a hyperlinked workbook and copy a range and paste it back to the workbook with the code in it.
There are 3 workbooks involved: an order chart workbook, a hyperlink to a Pro-Forma invoice and a hyperlink to an invoice. The two hyperlinks are in the order chart workbook.The code is based in the invoice template, when the code is executed it should do the following: it should leave the current workbook (which is the invoice) then activate an open workbook called 'Orders 2014.xlsm", next it should open another workbook which is hyperlinked to a cell in "Orders 2014", the workbook is a Pro-Forma invoice. The code is having issues with the following, it should be able to now copy a range in the ProForma and leave the workbook and go back to the invoice workbook and paste the info in a given range.
Please Login or Register  to view this content.