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
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