+ Reply to Thread
Results 1 to 2 of 2

Save As to a Specific Location and Name from Specific Cell Macro when clicking on a Shape

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    US
    MS-Off Ver
    2007, 2010
    Posts
    43

    Save As to a Specific Location and Name from Specific Cell Macro when clicking on a Shape

    Sorry for the mouthful Title...

    What I am hoping to do is have a Macro 'linked' to a shape in a sheet that will do the following:
    1. Save As
    2. Save to a specific location (on a public drive)
    3. Save name taken from a Concatenation of multiple cells
    4. Close file
    All when clicking on a shape in the sheet.

    I do not have any VBA knowledge and minimal Macro experience.

    This will be a file that operators input (via RF Scanners) serial numbers into and it gets saved. I would like this to be simple for them...enter name and date here, click this shape to go to this tab (I have this done), scan these serials and when finished click this 'shape' to save as and close.

    We are running Excel 2010 and 2007.

    Thank you in advance for any help.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,940

    Re: Save As to a Specific Location and Name from Specific Cell Macro when clicking on a Sh

    You're really asking for a solution to be designed, tested and implemented ... without providing an awful lot of detail, or sharing what you have done so far.

    You may want to consider buying points and posting your question in the Commercial Services Forum.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1