Alignment issue with Multibox

[#1]

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...

[VishalWaghole]

Hello,

Could you please possible to attach your sample application.

- Regards,

Vishal Waghole

[#3]

Hi Vishal,

PFA sample application for your Reference.

BRegards,

Reena. Abraham