Excel: date as filename vba

Im using this line to save a worksheet as a workbook. I want to use a date from the sheet as part of the filename. Vba doesnt like it. Im pretty sure I need to use 'Format..."dd-mm-yy"' around or within 'sh.range("q3")' But whatever ive tried is giving an error. Any guidance gratefully received. Thanks ActiveWorkbook.SaveAs FileName:="/Users/User/Desktop/" & sh.Name & sh.Range("Q3")

This question generated 37 answers. To proceed to the answers, click here.

This thread is current as of April 24, 2017.

For more resources for Microsoft Excel