I am just wondering how this is possible. I am working on a project for work to make things automatic, but I am having a struggle to find a way to have the VBA to save it as a name that is on the form. I have show the formula in D2 that is in D3. I want the file name to be what is in D3, but it will be on a xmlx as this vba will live in a different workbook.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
a | b | c | d | |
1 | Name | Tomato | ||
2 | Product Number | Product 1234 | =CONCATENATE(B2," ",B1,TEXT(TODAY(),"yyyy-mm-dd")) | |
3 | Product 1234 Tomato2019-07-03 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Last edited: