Formatting textbox exported to ppt

tim_albers — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Formatting textbox exported to ppt

m_woolf — Wed, 11 Apr 2018 16:00:45 GMT

ppAlignCenter has the numeric value 2

change that line to say

.TextFrame.TextRange.ParagraphFormat.Alignment = 2

tim_albers — Wed, 11 Apr 2018 16:24:43 GMT

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