+ Reply to Thread
Results 1 to 4 of 4

Need help to modify Variable strDocPath to a Select files (Dialogwindow)

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    109

    Need help to modify Variable strDocPath to a Select files (Dialogwindow)

    Hi guys could someone help me to change the code from an Path ("C:\xxxx\xxx\" to a Dialogwindow
    the variable is:strDocPath

    in this case

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Need help to modify Variable strDocPath to a Select files (Dialogwindow)

    Not really sure what you are looking for but perhaps it is
    Please Login or Register  to view this content.
    But it you wish to change the path (strDocPath) then I think you need

    Please Login or Register  to view this content.
    in order to change the path. You also need to dim intResult as Integer

    Alf
    Last edited by Alf; 03-16-2015 at 12:50 PM.

  3. #3
    Forum Contributor
    Join Date
    02-23-2015
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    109

    Re: Need help to modify Variable strDocPath to a Select files (Dialogwindow)

    Thank you alf solved!

    Works like a charm!

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Need help to modify Variable strDocPath to a Select files (Dialogwindow)

    You are welcome.

    Thanks for feedback.

    Alf

+ 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. [SOLVED] Modify existing code to select file instead of select folder
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 09:41 AM
  2. Select And Modify Duplicate Values
    By exarranum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2013, 08:08 AM
  3. Replies: 1
    Last Post: 10-27-2012, 02:54 AM
  4. [SOLVED] Modify this code to select different column
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2012, 11:52 AM
  5. How can I modify the SELECT statement?
    By wliong in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-08-2006, 12:09 PM

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