Inserting picture in Excel 2007

[proghelp]

Have a customized form in Syteline that will take Purchase Order information and insert it into an Excel template.

Each buyer has a signature file that gets inserted into each page of the Excel spreadsheet. The code currently used is:

cColumn = string((60 * i_page) - 2).
cRange = "i" + cColumn.
chWorksheet:Range(cRange):Select.
chWorksheetictures:Insert(w-signature-bmp).

This results in the embedded signature in Cell I58, I118, etc.

This works in Excel 2003, however, in Excel 2007 it inserts it into the top left of the page (B5). Any ideas?

 

[mosfin]

try to add this after inserting the picture:

assign
  chExcel:Selection:Top = chWorkSheet:Range(cRange):Top + [COLOR=#800000]20[/COLOR] 
  chExcel:Selection:Left = chWorkSheet:Range(cRange):Top + [COLOR=#800000]20[/COLOR] 
  .