Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an Image in an Excel sheet using VBScript.
range("B9").Select
ActiveSheet.Pictures.Insert( _ "C:\My Pictures\Sample.jpg") -- Regards, Tom Ogilvy "Vishal" wrote in message oups.com... Hi.. I've to insert an image in excel sheet using VBSCript. Can anyone please guide me ? Vishal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an Image in an Excel sheet using VBScript.
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an Image in an Excel sheet using VBScript.
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" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting an image into a cell | New Users to Excel | |||
Inserting an image or line | Excel Worksheet Functions | |||
Inserting .bmp image using VLOOKUP | Excel Programming | |||
Inserting .bmp image using VLOOKUP | Excel Programming | |||
Inserting CGM images in Excel changes image aspect ratio | Excel Programming |