Inserting an Image in an Excel sheet using VBScript.

Hi..
I've to insert an image in excel sheet using VBSCript.
Can anyone please guide me ?

Vishal

range("B9").Select
ActiveSheet.Pictures.Insert( _
"C:\My Pictures\Sample.jpg")

--
Regards,
Tom Ogilvy


"Vishal" <[email protected]> wrote in message
news:[email protected]...
> Hi..
> I've to insert an image in excel sheet using VBSCript.
> Can anyone please guide me ?
>
> Vishal
>

Thanks Olive..
I tried that and it works perfect when i use this code in a vb macro.
The problem is that i want to use it in a Quick Test Pro script.. and
since it supports the VBScript, i thought that a normal VBScript code
wud work in it. But when i use this piece of code in my QTP script, it
gives an errror at the line
Range("B9").select - Type mismatch.
u've any clue ?

I think i'll post a new topic with the heading - Inserting an image in
an excel sheet using QTP !

Thanks
Vishal

If the script uses automation to control excel, you would naturally have to
prepend the appropriate qualifications to the elements of the code to direct
it to the proper object.

--
Regards,
Tom Ogilvy


"Vishal" <[email protected]> wrote in message
news:[email protected]...
> Thanks Olive..
> I tried that and it works perfect when i use this code in a vb macro.
> The problem is that i want to use it in a Quick Test Pro script.. and
> since it supports the VBScript, i thought that a normal VBScript code
> wud work in it. But when i use this piece of code in my QTP script, it
> gives an errror at the line
> Range("B9").select - Type mismatch.
> u've any clue ?
>
> I think i'll post a new topic with the heading - Inserting an image in
> an excel sheet using QTP !
>
> Thanks
> Vishal
>