PDA

View Full Version : Solved: Hash Problems



paulked
05-29-2007, 05:36 PM
I am creating file names using the following code:

ActiveWorkbook.SaveAs Filename:=("C:\Pyranha\Records\" & LYear & "\" & _
"Week " & LWeek & "\" & Range("F1").Text & "\" & Range("A1").Text & ".XLS")

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
05-29-2007, 05:45 PM
Have you tried using Range("A1").Value instead of .Text?

paulked
05-29-2007, 06:03 PM
Super!

Many thanks :bow: