I'm writing script that make a Excel file and write some
information from the Assembly.
To add picture (logo) to the sheet I'm use this code:
.Left = xlApp.ActiveSheet.Range("B1").Left
.Top = xlApp.ActiveSheet.Range("B1").Top
.Placement = 3
.PrintObject = True
And it worked good. But ActiveSheet.Pictures.Insert
make link to the picture. And if I send this Excel file to another
PC logo will be lost.
That why I try use this code:
Call xlApp.ActiveSheet.Shapes.AddPicture(LogoPath, msoCFalse, msoCTrue, 100, 100, 100, 100)
But logo doesn't insert. Excel file creates without
And I don't understand why.