View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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