Saving the spreadsheet only with no code? Selecting shapes too.
1.) Is there a way to save a file, but only save just the worksheet data
and not all of the VBA code?
I am currently testing some hardware and i save a new file for each new
serial no. Problem is, each excel file is like a half a MEG! Hoping to
make the filesize much smaller.
2.) I import a screenshot (.bmp) of the test equipment onto the
spreadsheet. But my code doesn't erase the last screenshot. So the images
keep getting layed down on top of one another. Need to select the image
and delete. I just cant figure out how to select it. Found some code on
the web, but it didn't seem to work. It's the only image so i can select
all.
thanks,
groundhog
|