Hi Everyone,
Im new here. I want to create a macro that does the following and I dont know if its possible.
Hyperlink to a document per the cell so like cell A1 links to one document, A2 to another and so on. I can do this portion manually of course but the tricky part comes that I want to put a quantity in this cell so say a quantity of 10 in cell A1. I need excel to open the hyperlink automatically and print it out based on the quantity entered in the cell.
In goofing around, I can easily hyper link documents, I created a macro to print out the quantity that is in the cell, problem is it only prints out the number say 10 that I typed in the cell and not the hyperlinked document.
Any help is greatly appreciated.
Im new here. I want to create a macro that does the following and I dont know if its possible.
Hyperlink to a document per the cell so like cell A1 links to one document, A2 to another and so on. I can do this portion manually of course but the tricky part comes that I want to put a quantity in this cell so say a quantity of 10 in cell A1. I need excel to open the hyperlink automatically and print it out based on the quantity entered in the cell.
In goofing around, I can easily hyper link documents, I created a macro to print out the quantity that is in the cell, problem is it only prints out the number say 10 that I typed in the cell and not the hyperlinked document.
Any help is greatly appreciated.
