using a cell value to name a newly created workbook
Hello,
I want to use the value in a specific cell to appear as part of the
name of a newly created workbook, which is created following input into
the original workbook. i.e. the user enters the name of a company and
when the macro is run, the name of the company appears as the filename
of the workbook and the workbook is saved to the users desktop,
how would I go about this?
regards,
Matt
|