Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying automate adding a picture to an excel sheet using JScript
(I would imagine the language shouldn't matter that much). After doing quite a bit of research I tried writing the following code but I get an error saying that the 'Pictures' collection is null or not an object. I can't seem to figure out what I should be doing: var book = new ActiveXObject("OWC10.Spreadsheet"); var sheet = book.Worksheets[1]; var range = sheet.Range("A1"); range.Activate(); sheet.Pictures.Add( PATH_TO_LOGO_BMP ); Any suggestions? thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |