This snippet of Excel code works
sPath = "G:\OIL4LESS\FUNDING\RESEARCH\" + StNam + ".gif" Sheets("Charts").Select 'added...else next fails and trashes Excel WSc.ChartObjects(Chart_Name).Activate ActiveChart.Export Filename:=sPath, FilterName:="GIF"
Want way to do equivalent of following
pPath = "G:\ANALOG\HVREG\Boards\TITANTWO\CodatronD" + vNam + ".gif" ActiveSheet.Shapes("Picture 1").Select ActiveSheet.Shapes("Picture 1").Activate ActiveSheet.Export Filename:=sPath, FilterName:="GIF"
Can find no way to activate selected shape. Can find no way to export selected shape.
Help?
** Also, i have made a number of shapes/pictures in the spreadsheet; how the heck can i find their names - alternately,how can i name them?Thanks