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



In article ,
(Elby) wrote:

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!