Trouble setting variable as filename with 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!
 
J

JE McGimpsey

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
 
E

Elby C

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!)



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top