I have a litle problem with Excel and Picture

MantasD
MantasD Member Posts: 4
edited 2006-12-19 in NAV/Navision Classic Client
Can sombody help insert logo into excel?

I have search this forum, but i havn't find anything that culd me help.


XlWrkBk := XlApp.Workbooks.Add(-4167);
XlWrkSht := XlWrkBk.ActiveSheet;
//XlWrkSht.PageSetup.LeftHeaderPicture.Filename := FilePlace;
//PageSetup.CenterHeaderPicture.Filename := FilePlace; 
  XlWrkSht.PageSetup.CenterHeaderPicture.Filename := FilePlace;
  XlWrkSht.PageSetup.CenterHeaderPicture.Height := 197;  
  XlWrkSht.PageSetup.CenterHeaderPicture.Width := 418;
  XlWrkSht.PageSetup.CenterHeaderPicture.Brightness := 0.36;
  XlWrkSht.PageSetup.CenterHeaderPicture.ColorType := 1;
  XlWrkSht.PageSetup.CenterHeaderPicture.Contrast := 0.39;
  XlWrkSht.PageSetup.CenterHeaderPicture.CropBottom := 0;
  XlWrkSht.PageSetup.CenterHeaderPicture.CropLeft := 0;
  XlWrkSht.PageSetup.CenterHeaderPicture.CropRight := 0;
  XlWrkSht.PageSetup.CenterHeaderPicture.CropTop := 0;
  XlWrkSht.PageSetup.CenterHeader := '&G';
but this do not work.

Comments

Categories