Formatting textbox exported to ppt

[tim_albers]

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

[m_woolf · Accepted solution]

ppAlignCenter has the numeric value 2

change that line to say

.TextFrame.TextRange.ParagraphFormat.Alignment = 2

[tim_albers]

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