Format code no longer works
How is Fname declared? What is its value before the line below is
executed?
In article ,
CLR wrote:
Hi All.........
I've used this line of code in past workbooks and it worked fine for
appending a date on the end of a filename
Fname = Fname & Format(Date, "_Mmm_dd_yyyy")
Now, I'm trying the same thing in a new workbook, after a re-install of my
XL97, and I get the following error msg
"Compile Error,,,Wrong number of arguments or invalid property assignment"
Anybody know what the trouble might be?
TIA
Vaya con Dios,
Chuck, CABGx3
|