Am 05.03.2014 um 08:19 schrieb Osswald Oliver <[email protected]>:
> Hi,
>
> ===========
> dim book as new XLBookMBS(false)
>
> // == Changed original code from here
> Dim format As XLFormatMBS
> format = book.AddFormat
> format.FillPattern = XLFormatMBS.FillPatternSolid
> format.PatternForegroundColor = XLFontMBS.ColorYellow
> // == Changed original code to here
>
> // load template
> call book.Load(GetFolderItem("Template.xls"))
> dim sheet as XLSheetMBS = book.Sheet(0)
you need to define format after the load command.
Here it works.
Of course if file is in RGB mode, you need other RGB color value.
Sincerely
Christian
--
Read our blog about news on our plugins:
http://www.mbsplugins.de/
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
