Format.PageSetup.LabelHeight : Can this be programmatically updated with VBScript in any way?
I have a number of "base" templates with a set Label Height value (100mm). I want to programmatically change this based on a database value. The value (let's call it dbVal) can have a value of 0, 1, 2 or 3. If the value is 0 then Format.PageSetup.LabelHeight should be 100mm. If (dbVal == 1), LabelHeight should be "base"(which is 100mm) + 50mm. If (dbVal == 2), LabelHeight should be "base" + 100mm. If (dbVal == 3) then LabelHeight should be "base" + 150mm.
The PageSetup.LabelHeight is read-only, which leads to my question:
Is there any way that I can update Format.PageSetup.LabelHeight programmatically using VBScript? I currently have multiple templates for different products (around 200). Each of these have 4 variations to accommodate the possible variable label sizes. The result is that my total template count is around 800 which is an administrative nightmare to maintain. I'd like to try and get the total count to 1 for each product variation
-
I dont believe that is possible with VB script within the label format itself as you have already opened the label format and the label sizes have therefore need set.
Are your product labels similar in layout for each item? If so you could create some base templates that are the correct size and link these to a simple database with your product details in it. At print time you would then select the label size required, then which product to print from the database lookup and then type/add any print time variable information (if required and configured) before printing the desired labels
0
Please sign in to leave a comment.
Comments
1 comment