Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tim_albers
Contributor
Contributor

Formatting textbox exported to ppt

Hi all,

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:

ActiveDocument.GetSheetObject(TX01).CopyTextToClipboard   

with objPresentation.Slides(3).Shapes.Paste

.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

end with

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.


Many thanks

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

ppAlignCenter has the numeric value 2

change that line to say

.TextFrame.TextRange.ParagraphFormat.Alignment = 2

View solution in original post

2 Replies
m_woolf
Master II
Master II

ppAlignCenter has the numeric value 2

change that line to say

.TextFrame.TextRange.ParagraphFormat.Alignment = 2

tim_albers
Contributor
Contributor
Author

Thanks a lot for the swift response! Works like a charm