+ Reply to Thread
Results 1 to 2 of 2

Checking for / Copying a file from external SharePoint site

  1. #1
    Registered User
    Join Date
    02-08-2005
    Location
    Kent, UK
    MS-Off Ver
    2010
    Posts
    69

    Question Checking for / Copying a file from external SharePoint site

    I'm trying to either check for a file on an external SharePoint folder or ideally copy the file to our network.

    I've tried the usual workbook open commands and filecopy commands but nothing is working.

    Basically I'd like to check for a new file (the files are normally dated in various formats - I can use the format (now... command)) and download them to our network where the macro can continue with its formatting and file commands.

    I can't find any way to open or even check for files on the SharePoint folder. The SharePoint folder has a username and password to enter it.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Checking for / Copying a file from external SharePoint site

    It's worth trying something like...

    Please Login or Register  to view this content.
    to detect the file. You can get the path from right clicking on the file in Sharepoint and copying the shortcut. You may need to trim off the http: prefix.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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