+ Reply to Thread
Results 1 to 10 of 10

Create Input Box / Save File As

  1. 12-17-2009, 12:19 PM #1
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Create Input Box / Save File As

    Hi there. First post so bear with me!

    I am looking for some macro code to create an Input box which will prompt the user to enter a specific date (not todays date so NOW function is not appropriate). This will in turn cause the file to be saved in a specific folder with the date becoming the name of the saved file.

    Does this make sense? Any help greatly appreciated
    Reply With QuoteRegister To Reply
  2. 12-17-2009, 01:29 PM #2
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Create Input Box / Save File As

    Hello Smythe78,

    Ceud mìle fàilte!
    Welcome to the Forum!

    Are the files Excel workbooks? Can you give and example of the name before and after?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 12-17-2009, 02:42 PM #3
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Create Input Box / Save File As

    Hi Ross!

    Thanks for reply. It is indeed Excel files I am working with. It uses just one sheet in the workbook. When I recieve the file it is called something along the lines of SEI Inspector Credit Report 17.12.2009 and I would like to save it as something along the lines of '17.12.2009 SEI Report'.

    This is to be the beginning of a much larger macro but I thought I would ease myself in gently!

    Is your name anything to do with the Leith here in Edinburgh?
    Reply With QuoteRegister To Reply
  4. 12-17-2009, 09:06 PM #4
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Create Input Box / Save File As

    Hello Smythe78,

    Sorry for the delay. The furnace broke last night and I have had to deal will the repair people coming and going all day. I am still not sure what you need. This macro will open the "SaveAs" dialog and let the user choose the folder and file. Have a look at this and let me know if this is close to what you are after.

    As for my name, you're right. My family emigrated from Scotland about 150 years ago. The name has been passed down through the generations. Here in the states there about 4000 people with Leith as a first name or surname. 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-18-2009, 04:45 AM #5
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Create Input Box / Save File As

    Nae bother. You dont want a broken furnace at this time of year!

    Thanks for that. That code works great but not quite what I am looking for.
    To be more specific I suppose I would like an input box for user to enter date because I dont want to give the user a choice of what the file is called or where it is stored.
    So for example I would like the Input box to say 'Please enter date of Report' and once the date has been entered in box and OK has been clicked , the macro would then go on to Save As in a pre-specified folder. (for purpose of example folder would be C:\Chambers-Smith\documnets\work)

    Andy
    Reply With QuoteRegister To Reply
  6. 12-18-2009, 05:37 AM #6
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Create Input Box / Save File As

    Hello Andy,

    I will work on that in the morning. I'm heading off to bed now. Thanks for the input.
    Reply With QuoteRegister To Reply
  7. 12-19-2009, 04:36 AM #7
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Create Input Box / Save File As

    That would be great thanks
    Reply With QuoteRegister To Reply
  8. 01-11-2010, 07:08 AM #8
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Create Input Box / Save File As

    Hi there. Apologies for thread bump but back at work and still struggling with same problem!

    I am looking for some macro code to create an Input box in excel which will prompt the user to enter a specific date (not todays date so NOW function is not appropriate). This will in turn cause the file to be saved in a specific folder with the date becoming the name of the saved file.

    Any suggestions would be greatly appreciated

    Cheers
    Reply With QuoteRegister To Reply
  9. 01-11-2010, 04:05 PM #9
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Create Input Box / Save File As

    Hello Andy,

    Bliadhna Mhath Ùr!

    Glad you bumped the post. This macro should be closer to what you want. This will save a copy of the workbook the macro is in to the directory you specify and using a name you provide containing the date the user entered. The parameters for the file and folder are marked in blue.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 01-12-2010, 06:20 AM #10
    Smythe78 is offline
    Registered User
    Join Date
    12-17-2009
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Create Input Box / Save File As

    That is superb! Thanks for your help. Is exactly what I was after.

    Cheers!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1