Dear all, 

I have created an Excel document that creates a document library code using VBA based on user input.

e.g.

Company = A

Type of Document = B

Date of Execution = C 

and so on.

Based on what the user enters, when they click the create code button, some VBA runs in the background and creates a document code e.g. US-ABC-E-123-1

The intent is for that document code that is created in cell B5 to be printed on to a 45x15mm label via our Zebra label printer. However I am struggling to find a way to get excel to print the contents of just that cell at the right size. 

The current workaround is that clicking a print button on the worksheet which opens a template in word (which is 45×15), pastes in the code, and then the user prints it in the normal File-Print dialog. 

Any ideas on how to solve this issue would be very very much appreciated!

​Dear all,  I have created an Excel document that creates a document library code using VBA based on user input. e.g.Company = AType of Document = BDate of Execution = C  and so on. Based on what the user enters, when they click the create code button, some VBA runs in the background and creates a document code e.g. US-ABC-E-123-1 The intent is for that document code that is created in cell B5 to be printed on to a 45x15mm label via our Zebra label printer. However I am struggling to find a way to get excel to print the contents of just that cell at the right size.  The current workaround is that clicking a print button on the worksheet which opens a template in word (which is 45×15), pastes in the code, and then the user prints it in the normal File-Print dialog.  Any ideas on how to solve this issue would be very very much appreciated!  Read More

​