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

Hi

Do you have code in the sheet module ???

If you use Activesheet.copy it will create a workbook with only this sheet

You can delete shapes like this

Sub Shapes1()
'Delete all Objects except Comments
On Error Resume Next
ActiveSheet.DrawingObjects.Visible = True
ActiveSheet.DrawingObjects.Delete
On Error GoTo 0
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"groundhog1" wrote in message lkaboutsoftware.com...
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

if you don't need formulae, you could save the sheet as a CSV

"groundhog1" wrote in message
lkaboutsoftware.com...
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

OOPS!

Thanks, It worked great except I was wrong about not having any other
shapes on my worksheet. I just deleted my big "start everything" button.

So I guess I have to identify the shape somehow.

groundhog

See http://www.rondebruin.nl/controlsobjectsworksheet.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"groundhog1" wrote in message lkaboutsoftware.com...
OOPS!

Thanks, It worked great except I was wrong about not having any other
shapes on my worksheet. I just deleted my big "start everything" button.

So I guess I have to identify the shape somehow.

groundhog