title: Printing documents from a hyperlink in excel
body: <p>i am trying to create a VBA code to open a hyperlink in a cell, (This cells hyperlink changes depending on other variables in the spreadsheet, but i don't believe that matters)</p>
  <p>Basically i want to press the macro, it will open the hyperlink, which could either be a document in excel or word, i then want it to print that document by an amount specified in a different cell in the same spreadsheet as the hyperlink.</p>
  <p>I also want the document to not pop up, or at least close after printing has finished.</p>
  <p>The printer it would need to print from is called SRV-papercut1</p>
  <p>I have been attempting to code it myself, but cant quite manage, Any ideas?</p>
  <p><strong>Amount cell</strong>: J20 <strong>Hyperlink Cell:</strong> O18</p>
  <p>I have attached a photo of the spreadsheet so you can see it.(I have cut off the company logo on the left for privacy reasons) <a href="https://i.stack.imgur.com/NFh8P.png" rel="nofollow noreferrer">One Button Print Spreadsheet</a></p>