This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i am successfully using a module to export QV text boxes and Pictures to an existing ppt slide.
However, the code snippet below causes some trouble:
.TextFrame.WordWrap = True
.Top = 351.6238
.Left = 53.92496
.Width = 64.2489
.Height = 21.81095
.TextFrame.TextRange.Font.Size = 9
.TextFrame.MarginLeft = 0
.TextFrame.MarginTop = 0
.TextFrame.MarginRight = 0
.TextFrame.MarginBottom = 0
.TextFrame.TextRange.ParagraphFormat.Alignment = ppAlignCenter
The code highlighted in blue results in the following error: "The specified value is out of range"
I can not figure out which values to set to make any alignment settings (msoAlignRight etc. does not work as well).
I am using Microsoft Office Professional Plus 2013 and QlikView 11.20.
ppAlignCenter has the numeric value 2
change that line to say
.TextFrame.TextRange.ParagraphFormat.Alignment = 2
View solution in original post
Thanks a lot for the swift response! Works like a charm