Save file as sequential

P

psipsi

Is there any code which would enable me to save the excel file as a
predefined sequential number.

I.E. I have products with serial numbers 050501AB, 050502AB etc etc

The serial number is scanned in by a barcode reader and located in a
predefined cell.
I want to save the excel workbook as this serial number automatically.

Any help would be appreciated.
 
G

Guest

ActiveWorkbook.SaveAs Filename:=Range("A1")

Replace A1 by your predefined cell! If you want to place the file in a
directory other then your default directory, insert also the required path:

savepath = "C:\dir1\dir2\"
ActiveWorkbook.SaveAs Filename:=savepath & Range("A1")

Regards,
Stefi


„psipsi†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for sequential numbering 8
Adding Data Automatically 1
loop thru cells to find matching record 2
Save as crashes Excel - sometimes 7
Access Sequentially numbered column that resets with each new sample 0
Open Workbook Macro - with a twist 1
Deleting all code in new file only (creating using save as) 15
autonumber plus 2

Top