[RESOLVED] [2005] Add Picture to Excel File

[craigreilly]

Many sites mention Excel automation, but fail to inform how to insert a picture to the Excel worksheet.

Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
oXL = CreateObject("Excel.Application")
oXL.Visible = True 'Move to Bottom after Debugging
 
oWB = oXL.Workbooks.Add
oSheet = oWB.ActiveSheet
 
oSheet.Visible = True
oSheet.Pictures.insert("logo.jpg").Select()

does not seem to work...

The rest of my code works to add and format text, so I know the reference is correct.

Thank in advance if anyone can help me.