Alignment issue with Multibox

Thu, 20 Mar 2014 06:10:19 GMT

Hi All,

I have using Macro to Export the sheet objects to Excel, But while i Export the Multibox to excel the text Alignment is becoming 'Center' though i have given the Alignment as 'Left' in presentation. I am using the following Code for export.

-----------------------------------------------------------------------------------------

set mybox = ActiveDocument.GetSheetObject("MB51")

mbp = mybox.GetProperties

mbp.TextAdjust = 0

mbp.NumAdjust = 0

mybox.SetProperties mbp

mybox.CopyTableToClipboard(true)

curSheet.Range("A" & 15).Select

curSheet.Paste

---------------------------------------------------------------------------------------

Kindly Help me out with a solution for this.

Thanks in Advance...

Re: Alignment issue with Multibox

VishalWaghole — Thu, 20 Mar 2014 07:28:38 GMT

Hello,

Could you please possible to attach your sample application.

- Regards,

Vishal Waghole

Re: Re: Alignment issue with Multibox

Thu, 20 Mar 2014 07:52:50 GMT

Hi Vishal,

PFA sample application for your Reference.

BRegards,

Reena. Abraham

topic Alignment issue with Multibox in QlikView

Alignment issue with Multibox

Re: Alignment issue with Multibox

Re: Re: Alignment issue with Multibox