vba code To Save Copy As Cell.Value

[jessmendez01]

im working on an invoice ..i need a vba code to save a copy of what im working on under a directory and save with the name: (example: the invoice number-Original.xls so it would save as : 123456-Original.xls

any thoughts

[Leith Ross]

Hello jessmendez01,

Where is the invoice number on the worksheet?

What is the directory path are you using?

[mdmackillop]

Google "excel savecopyas"