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