+ Reply to Thread
Results 1 to 5 of 5

VBA to ask for Value then use that value to include on DIR

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    VBA to ask for Value then use that value to include on DIR

    I set my Dir as seen below. Within that Folder "Tool Run" I have sub folders EX:"Run #1, Run #2, ...." I want a message to pop up asking what Run # folder would you like the document placed into.

    Answer would be say "1" or "2" or "3".....

    Then I would like to reflect 'JobDir' to include this Answer so it places the sheet generated into that folder. Right now the code works but only to the main folder.



    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA to ask for Value then use that value to include on DIR

    Maybe something like this:
    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Re: VBA to ask for Value then use that value to include on DIR

    I thought that would work but after making the addition this is what happened.
    1. changed File name from "ToolRun_Scan Liberty_20-Nov-2017" TO "Run #1ToolRun_Scan Liberty_20-Nov-2017"

    That's it really no location change for the saved file
    It saved the file in the main "Tool Run" Folder.... not in the Run #1 folder as specified by input box

    Here is total code maybe you can see why.

    Please Login or Register  to view this content.

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA to ask for Value then use that value to include on DIR

    Try this:
    Please Login or Register  to view this content.

  5. #5
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA to ask for Value then use that value to include on DIR

    Thanks for the rep. points.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sumifs include/ include criteria
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2016, 07:34 AM
  2. Replies: 17
    Last Post: 08-26-2014, 01:05 PM
  3. [SOLVED] Editing a Macro to include multiple rows and include text formatting for leading zeros
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2014, 09:50 AM
  4. To Include or Not Include Holidays When Forecasting
    By mycon73 in forum Excel General
    Replies: 7
    Last Post: 11-03-2013, 04:09 PM
  5. to use v look up .maybe include if -not sure
    By logcabin12 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-29-2012, 09:48 AM
  6. VBA to include offset
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2011, 11:35 AM
  7. Include value
    By RDx in forum Excel General
    Replies: 3
    Last Post: 11-07-2007, 09:47 PM

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