changing the properties of an excel file
 

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

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

changing the properties of an excel file
 

Actually I should have also given you some more information on this, because
I have just encountered almost the same problem
with save as...
this is what Ron de Bruin suggested:

ActiveWorkbook.SaveAs FileName:="C:\NameOfYourWorksheet" & Format(Now,
"dd-mm-yy h-mm-ss") & ".xls"

It worked great for me and has a timestamp so previous copies do not get
overwritten.

"ufo_pilot" wrote:

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