Saturday, April 3, 2010

VBScript - How Can I Add a Background Picture to an Excel Worksheet?

VBScript - How Can I Add a Background Picture to an Excel Worksheet? AND How to insert a picture into a worksheet (without making it the background)?

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True

Set objWorkbook = objExcel.Workbooks.Add
Set objWorksheet = objWorkbook.Worksheets(1)
objWorksheet.SetBackgroundPicture "C:\Scripts\Test.jpg"

[Via]