I have a VBA that has an statement:
Filename = "" & WO & "_" & Tract & "_" & Supplier & "_" & Dates & "_" & Time
& ""
I want to type the time in the excel cell €œ=now()€� instead of typing:
Dates = 20050923 (September 23, 2005)
Time = 1145 ( 11:45AM)

Every time I type in the cell =Now() I have an error message that says €œthe
file cannot be found€�
Does anybody knows how to do it?

Thanks.
Maperalia