Need a "Save" macro that will autoname the file - based on part # on excel form

I have an excel Inspection Form that a guy fills out -- then he needs to "save" the form in a folder.    Can I have the macro use the "part number" listed
on the checklist to autofill the filename to save it under?   Do I copy/paste it somehow and add
the " .xls "    ????  Thanks
SRMoxyAsked:
Who is Participating?
 
Randy DownsOWNERCommented:
0
 
Saqib Husain, SyedEngineerCommented:
Can you upload the file? You may, if necessary, delete all other info and keep the part number.

Will there be only one file for one part number? If there could be more the How would you want to name them separately?
0
 
SRMoxyAuthor Commented:
Here's a sample  -  "H5" is the part number I'd like to use for the filename.   ( Yes, there could be duplicates.  Any suggestions on how to tag them would be great.)   Thanks a bunch!
Sample-Checklist.xls
0
 
Rob HensonFinance AnalystCommented:
Similar question asked previously:

File Save Routine

Cheers
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.