Solved: Hash Problems

[paulked]

I am creating file names using the following code:
[vba]
ActiveWorkbook.SaveAs Filename:=("C:\Pyranha\Records\" & LYear & "\" & _
"Week " & LWeek & "\" & Range("F1").Text & "\" & Range("A1").Text & ".XLS")
[/vba]
The contents of F1 is always a text value and the contents of A1 is numerical.

I'm having a problem with the numerical value in A1...

If the value is small enough to be viewed in the cell on screen, no problem. But if it is too large and the screen is showing #### then the file is saved as ####.XLS.

Any advice please?

Best Regards

Edited 30-May-07 by geekgirlau. Reason: insert line breaks

[geekgirlau]

Have you tried using Range("A1").Value instead of .Text?

[paulked]

Super!

Many thanks