Hi, I’ve setup a invoice document within excel. I was wondering if there was ways to get excel to automatically save the document with a new file name that corresponds to the invoice number. At the moment the files are being saved manually using the save as function. However sometimes people forget to do this and save over the top of the last invoice.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving files automaticly in excel
- Thread starter Nik1979
- Start date
Hi!
Try posting in forum707 or forum68
In VBA, the syntax
ActiveWorkbook.Close True, "Invoice" & range("A1"
will save the document at current path with the name "Invoice" and whatever resides in cell A1
Roy-Vidar
Try posting in forum707 or forum68
In VBA, the syntax
ActiveWorkbook.Close True, "Invoice" & range("A1"
will save the document at current path with the name "Invoice" and whatever resides in cell A1
Roy-Vidar
- Status
Similar threads
