changing the properties of an excel file
try
ActiveWorkbook.Save
" wrote:
i have an excel file with different properties....
what i want to do is when i click a button i want the file to be save
and a certain status field to be selected and saved....
i thought this wud be donr using a macro...but when i record a
macro....and i go select file save as ...and it save then i stop the
record macro ...and when i view the code there i nothing....
and ideas....
thanks
|