Using part of cell entry as file name

[ANDREWA]

Hi, Im using the following line in vba to save a file, getting the file name from a cell, works perfectly.

FileName = ThisWorkbook.Worksheets("Master File").Range("A3").Value

But, I want to only use the last 5 digits of the cell entry as the file name. Thought the following would do it, but doesnt work, what am i doing wrong? Help?

FileName = ThisWorkbook.Worksheets("Master File").Right(Range("A3").Value, 5)

[StephenR]

FileName = Right(ThisWorkbook.Worksheets("Master File").Range("A3").Value, 5)