Trying to save a worksheet
Hi
try something like
sub save_it
dim fname
dim fpath
fpath="c:\temp\"
fname=Format(now,"MMDDYYYY_hhmmss")
activeworkbook.saveas fpath & fname
end sub
--
Regards
Frank Kabel
Frankfurt, Germany
Saving a worksheet with different names wrote:
Help!!!
I recorded a macro to save as a worksheet in a workbook. I get the
save as dialog box. What I want to do is once my data is populated
in the worksheet to click my button (i want to attach my macro to )
save a new worksheet to the same directory every time with a
different name like a date.
for example
c:\temp\07152004
And also not show the save as box I don't want to have to click any
button just look in the temp directory and see file names.
is this doable?
|