I have an excel template which is used as an invoice. Based on the entries in three cells; "sales person", "company name", "date". I want to save to a particular directory and the file name should be e.g. c:/invoices/sales person-company-date.xls. depending on what was entered into the relevant cells.
I can create a string linking all these together but can't get the save as part to work. Can anyone help?
I can create a string linking all these together but can't get the save as part to work. Can anyone help?