PDA

View Full Version : vba code To Save Copy As Cell.Value



jessmendez01
05-11-2016, 09:30 AM
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
05-11-2016, 10:01 AM
Hello jessmendez01,

Where is the invoice number on the worksheet?

What is the directory path are you using?

mdmackillop
06-03-2016, 05:26 AM
Google "excel savecopyas"