Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dim Pict As Object
Dim p As Object Filename$ = "C:\aScopePic\jdpic7.png" DoThis$ = "c:\windows\wgetbin\wget.exe -t1 -O" DoThis$ = DoThis$ + "C:\aScopePic\jdpic8.png" DoThis$ = DoThis$ + " 10.32.54.19/Image.png" If Dir(Filename$) = "" Then Stop ret = Shell(DoThis$): ' Works so far, pic saved locally ' Now the following works ONLY if the Effic tab was on top when I run the VBA ' Otherwise the next line returns " Select method of range class failed" Worksheets("Effic").Range("B3:F18").Select Worksheets("Effic").Range("B3:F18").Activate ActiveSheet.Pictures.Insert (Filename$) ' I would like to be able to insert the picture onto any of the sheets ' THANK YOU !!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
Error 1004, "select method of range class failed" | Excel Programming | |||
Runtime Error "1004" Select Method of Range Class Failed | Excel Programming |