ExcelBanter - saving with VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - saving with VBA (https://www.excelbanter.com/excel-programming/307854-re-saving-vba.html)

Will the text always be the same

Workbooks("Report.xls").SaveAs "S:\Reports\Report" & _
format(data,"yyyymmdd") & ".xls"

--
Regards,
Tom Ogilvy

"havocdragon" wrote in message
...
Hello all =). I am programming a macro in VBA at work, and I've come
across
one major hicup. The macro I have is assigned to a button on a worksheet,
this macro then opens a report, sorts, formats, and references
information,
and then saves it to the network drive (so far no problems). The only
problem
I am having, is I wan't this file to save with text+current date everytime
I
run the macro. The problem I'm having with that, is no matter what I do,
once
the first entry has been made to the save as, it always is that. Any
thoughts
on how I could do this?

Dude thanks!!! I have been banging my head on that for a while. I knew it had
to be something similar to that, but for some reason I just couldn't get the
syntax right =)

"Tom Ogilvy" wrote:

Will the text always be the same

Workbooks("Report.xls").SaveAs "S:\Reports\Report" & _
format(data,"yyyymmdd") & ".xls"

--
Regards,
Tom Ogilvy

"havocdragon" wrote in message
...
Hello all =). I am programming a macro in VBA at work, and I've come
across
one major hicup. The macro I have is assigned to a button on a worksheet,
this macro then opens a report, sorts, formats, and references
information,
and then saves it to the network drive (so far no problems). The only
problem
I am having, is I wan't this file to save with text+current date everytime
I
run the macro. The problem I'm having with that, is no matter what I do,
once
the first entry has been made to the save as, it always is that. Any
thoughts
on how I could do this?