Hi,
I'm still quite new using macro's and VBA so i apologize if this doesn't make a lot of sense.
I'm trying to create a system that will allow me to enter weekly invoice information into one workbook and then export the information into the corresponding contractors invoice template saved in another workbook.
I've managed to import the information in to the correct templates but each invoice template must be saved as the invoice number once filled.
The invoice number is on the invoice.
So I guess my question is, Using a macro how do I save the workbook as the contents of a cell?
Sorry again if there not enough info still pretty new to this.
EDIT:
I have found part of the code which allows me to specify file name based upon a cell value.
Now i need to specify the folder location which it will be saved in.Public Sub SaveAsA1()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
Thanks for any help.
Bookmarks