We help IT Professionals succeed at work.

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

Medium Priority
356 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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?

Author

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
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Similar question asked previously:

File Save Routine

Cheers
Rob H
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.