title: How to send a file from clipboard?
body: <p>I want to copy a range of cells in excel sheet and send it via telegram bot as a picture programmatically using VBA.</p>
  
  <p>Here I copy the range as a picture:</p>
  
  <pre><code>Dim rCopy As Range
  Set rCopy = ThisWorkbook.ActiveSheet.Range("A14:C14")
  rCopy.copyPicture
  </code></pre>
  
  <p>This code sends HTTP request to the Telegram API:</p>
  
  <pre><code>Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
  URL = "https://api.telegram.org/bot&lt;TOKEN&gt;/sendPhoto?chat_id=&lt;ID&gt;&amp;photo=" &amp; rCopy
  objHTTP.Open "POST", URL, False
  objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
  objHTTP.send ("")
  </code></pre>
  
  <p>But I do not know how to get the file from <strong>Clipboard</strong> and put it to the request.</p>