title: Printing to DYMO Printer from Excel VBA
body: <p>I found some code online that says that you can print a label onto the Dymo printer. I have the reference DYMO Label Software v.8 reference enabled. The Code is as follows:</p>
  
  <pre><code>Dim myDymo As DYMO_DLS_SDK.DymoHighLevelSDK
  Dim dyAddin As DYMO_DLS_SDK.ISDKDymoAddin
  Dim dyLabel As DYMO_DLS_SDK.ISDKDymoLabels
  
  Set myDymo = New DYMO_DLS_SDK.DymoHighLevelSDK
  
  Set dyAddin = myDymo.DymoAddin
  Set dyLabel = myDymo.DymoLabels
  
  dyAddin.SelectPrinter dyAddin.GetDymoPrinters
  
  dyAddin.Open Environ$("USERPROFILE") &amp; "\My Documents\DYMO Label\Labels\BoardFile.label"
  dylabe.SetField "Text", "Lot Number: " &amp; Range("A" &amp; LR + 1) &amp; vbCr &amp; "Item Number: " &amp; Range("B" &amp; LR + 1) &amp; vbCr &amp; "Order Number:" &amp; Range("E" &amp; LR + 1)
  dyAddin.Print2 1, True, 1
  
  Set myDymo = Nothing
  </code></pre>
  
  <p>There is no error code but no label gets printed either so I'm lost on what to do next.</p>