Trouble setting variable as filename with date

  • Thread starter Thread starter Elby
  • Start date Start date
E

Elby

Hi,
I'm trying to set a variable as a filename, and keep getting a compile
error "Object required." - it selects my variable "Newfilename =" when
this happens

Here's a snip:

Sub Namefile()
Const Dirpath As String = "C:\WINNT\Profiles\elby\Desktop\"
Dim newfilename As String

Set newfilename = Dirpath & format((Date - 1), "mmm-dd-yy") & "_Pres"
& ".xls"
End sub

I'm working in VBA - Excel 97, new at this.
Any ideas much appreciated!
 
Object variables require the Set statement. Regular variables can use
the optional Let statement (but almost nobody does). Instead:


Public Sub Namefile()
Const Dirpath As String = "C:\WINNT\Profiles\elby\Desktop\"
Dim newfilename As String

newfilename = Dirpath & Format((Date - 1), "mmm-dd-yy") & _
"_Pres.xls"
End Sub
 
So simple, yet so much time I wasted trying to get that right! Thanks a
bunch - that's twice today you've helped me out (I also grabbed your
code from "Invalid use of null" - I've been trying to trim a range, and
this works!)
 
Back
Top