Need to format as string:
[VBA]
'//NEW
FileNameSrc = Format(wbDest.Range("B3"), "d-mmm-yy")
[/VBA]
Need to format as string:
[VBA]
'//NEW
FileNameSrc = Format(wbDest.Range("B3"), "d-mmm-yy")
[/VBA]
Cheers,
dr
"Questions, help and advice for free, small projects by donation. large projects by quote"
http:\\www.ExcelVBA.joellerabu.com