Closed Thread
Results 1 to 3 of 3

ChDir location, using a http link to sharepoint

  1. #1
    Forum Contributor
    Join Date
    03-27-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    290

    ChDir location, using a http link to sharepoint

    Hello all,

    I want to use the application.GetOpenFilename function in a specified location for the user to select the file within that location.
    I can change the directory by using ChDir and give this function a regular filepath however I am not able to give it a web URL link.

    The web URL link works as a folder which can be opened in explorer as part of a feature of Sharepoint. I would like to put the user at this default location so they can select the correct file within that location.
    Problem is that I receive the error message: "Path Not Found"

    Is there any way I can get around this?

    Kind Regards,
    Penfold

  2. #2
    Registered User
    Join Date
    11-16-2022
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1

    Re: ChDir location, using a http link to sharepoint

    Have you been able to figure this out? I am having the same issue with CHDir.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: ChDir location, using a http link to sharepoint

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Strange http link message in Workbook with macros
    By LydiasDad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 02:58 AM
  2. Tweak VBA to Move SharePoint Files to a Folder in Same Location
    By n_lindsey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2014, 03:21 PM
  3. Replies: 8
    Last Post: 01-30-2014, 03:12 PM
  4. link to external excel file via http
    By DanielZuercher in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2012, 06:32 AM
  5. Dynamic vlookup to a remote location in sharepoint
    By Robby1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 03:13 PM
  6. [SOLVED] HTTP link in Excel
    By Subs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2006, 04:10 PM
  7. HTTP link in Excel
    By Subs in forum Excel General
    Replies: 1
    Last Post: 04-02-2006, 02:50 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