Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Changing properties for Chart on Worksheet | Excel Discussion (Misc queries) | |||
File Properties Modified Date not changing | Excel Discussion (Misc queries) | |||
Properties transferring from excel cells to word file properties | Excel Programming | |||
How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) | |||
Changing the File Save Properties | Excel Programming |