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

Posted on 2011-04-20
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
Question by:SRMoxy
    LVL 29

    Accepted Solution

    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    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 Comment

    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!
    LVL 31

    Expert Comment

    by:Rob Henson
    Similar question asked previously:

    File Save Routine

    Rob H

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now