Using VBA how do I set the Font used by Dymo LabelWriter

July 27, 2018 at 13:26:20
Specs: Windows 10
When using a VBA Script in Excel to print a label to a dymo labelwriter 450 printer. I can set the text contents to go into the label's text boxes determined by the .label file but the printed label ignores the font settings in the .label file. How can I set these within the VBA macro

See More: Using VBA how do I set the Font used by Dymo LabelWriter

Reply ↓  Report •

#1
August 8, 2018 at 22:40:43
Changing the Default Font

You can select the default font to use for all your labels. You can easily change the font forindividual labels from the formatting toolbar.

To change the default font
1. Do one of the following:
For Windows, choose Preferences from the Edit menu.
For Mac, choose Preferences from the DYMO Label menu.

2. Select the General tab.
3. Under Default font, click Change.
4. Choose the font type, size, and style to use as the default font and then click OK.
5. Click OK to close the Preferences dialog box and apply your changes.

Good luck!


Reply ↓  Report •

#2
August 9, 2018 at 01:50:02
Hi Piter thanks for your reply explaining how to change the font size within the Dymo DLS.exe program, which I had already done to create the initial label layout. Unfortunately this is not the solution to my problem. The problem is when using a VBA macro in excel to print labels directly without having to go through the DLS program. The macro will read the label parameters in the .label file but the font size details are ignored. How do I create the VBA code to set the font parameters within the macro? My code will send text to the desired text boxes but it will not pick up the desired font style/size details.

Reply ↓  Report •

#3
August 9, 2018 at 06:28:16
Perhaps you can post your code?

The macro will read the label parameters in the .label file but the font size details are ignored

What do you mean by this?

Do you need to update the .label file via VBA?

Are you just reading from the .label file or do you write to it too?

When you read the file where are you holding the values? variables? textboxes?

A little more information is required so that we get the full picture of what you are trying to do.


Reply ↓  Report •
Related Solutions


Ask Question