• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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
0
SRMoxy
Asked:
SRMoxy
1 Solution
 
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 HensonIT & Database AssistantCommented:
Similar question asked previously:

File Save Routine

Cheers
Rob H
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now