+ Reply to Thread
Results 1 to 7 of 7

Replace ability to select folder with a hardcoded directory

  1. 05-25-2010, 02:13 PM #1
    dcgrove
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Replace ability to select folder with a hardcoded directory

    How would I go about removing the prompt that allows my users to choose the directory in the code below so that the path is hard coded in the macro? The path I need to point this macro to is :Y:\CRW\Dal\Department\ProChef\Kitchen Cuttings\Cutting Sheets


    Please Login or Register  to view this content.
    Thanks!
    Last edited by dcgrove; 05-25-2010 at 02:14 PM. Reason: Holy engrish batman!!
    Reply With QuoteRegister To Reply
  2. 05-25-2010, 02:44 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Replace ability to select folder with a hardcoded directory

    Maybe like this, but completely untested.

    The function Excludes is not defined.

    Please Login or Register  to view this content.
    Last edited by shg; 05-25-2010 at 02:46 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 05-25-2010, 03:45 PM #3
    dcgrove
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Re: Replace ability to select folder with a hardcoded directory

    My apologies, I thought I had included it. The function Excludes is below. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 05-25-2010, 03:53 PM #4
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Replace ability to select folder with a hardcoded directory

    This is all
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-25-2010, 03:59 PM #5
    dcgrove
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Re: Replace ability to select folder with a hardcoded directory

    SNB, thanks for the help! The code is throwing a "Run Time Error '13': Type Mismatch" error on this line.

    Please Login or Register  to view this content.
    Also, is it possible for it to not have the dialog box come up that is asking to confirm whether or not I want to replace the contents of the cells?

    Thanks!
    Reply With QuoteRegister To Reply
  6. 05-25-2010, 04:13 PM #6
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Replace ability to select folder with a hardcoded directory 

    Please Login or Register  to view this content.
    Last edited by snb; 05-25-2010 at 04:15 PM.
    Reply With QuoteRegister To Reply
  7. 05-25-2010, 04:18 PM #7
    dcgrove
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Re: Replace ability to select folder with a hardcoded directory

    SNB, now it is saying giving a "Runtime Error '424': Object Required" on the line below...

    Please Login or Register  to view this content.
    Any ideas why?
    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