Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 22

Thread: Upload multiple files to sharepoint document libraries - $50

  1. #11
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Hello PATSYS

    How would you upload the files if you were to upload the files manually?
    Would you use Windows Explorer to copy/paste and overwrite, or would it be an FTP client or a batch process or ...?
    I have not a lot of knowledge of this setup for Sharepoint, so coding this is not easy for me if I do not know how to approach the problem.

    Don't know if Dr still wants to proceed on it?

    Wigi
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  2. #12
    Join Date
    16th July 2006
    Posts
    37

    Re: Upload multiple files to sharepoint document libraries - $50

    Quote Originally Posted by Wigi View Post
    Hello PATSYS

    How would you upload the files if you were to upload the files manually?
    Would you use Windows Explorer to copy/paste and overwrite, or would it be an FTP client or a batch process or ...?
    I have not a lot of knowledge of this setup for Sharepoint, so coding this is not easy for me if I do not know how to approach the problem.

    Don't know if Dr still wants to proceed on it?

    Wigi
    Hi Wigi,

    We manually upload files to sharepoint document library by simply going to the site (https://xx) and clicking on the UPLOAD icon. I have not tried drag and drop from windows explorer to sharepoint explorer view. Will try this and revert.

    Please let me know if there is something else I can provide you with to help you out.

    I made a little search on this a while back and this link might also provide you with some insights.

    http://www.access-programmers.co.uk/...21#post1133921

    The poster got it to work, though it is MS ACCESS.

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  3. #13
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Hello

    From the link you directed me to, it is the upper half that is most important.
    While this works in Accessn we'll need to see if if works in Excel too.
    I have no Sharepoint, I cannot test. Did you try to do the steps but then in Excel?

    If that works, I could look at the code part in the topic.
    Including the other requirements you had.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  4. #14
    Join Date
    16th July 2006
    Posts
    37

    Re: Upload multiple files to sharepoint document libraries - $50

    Quote Originally Posted by Wigi View Post
    Hello

    From the link you directed me to, it is the upper half that is most important.
    While this works in Accessn we'll need to see if if works in Excel too.
    I have no Sharepoint, I cannot test. Did you try to do the steps but then in Excel?

    If that works, I could look at the code part in the topic.
    Including the other requirements you had.
    Hi Wigi,

    There are several obstacles in going the solution in the link I posted.

    First, it requires downloading and running a setup.exe which only IT administrators can do in our company.
    2nd, will this have to be done for all the users whom potentially will use this upload tool that I am putting up? If so, then I think I will have to abandon this approach.

    In the link I posted, there is a mention of mapping the sharepoint URL as a network drive. Perhaps you can look into the coding of this? Just tell me what I need to do to test it.

    Here is another similar solution

    http://www.excelforum.com/excel-prog...harepoint.html


    Thanks
    Last edited by PATSYS; March 5th, 2012 at 09:31. Reason: Add more resource links

    Excel Video Tutorials / Excel Dashboards Reports


  5. #15
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Hello

    I have written code to map a network drive. The code will then copy a certain file to the drive, and remove the mapping after 3 seconds.
    The letter Z is used to map. Please go through the code and change to suit.

    VB:
    Sub tst() 
         
        Const sSource As String = "C:\testfile.xlsx" 'change to suit
         
        With CreateObject("WScript.Network") 
             
            .MapNetworkDrive "Z:", "\\FSERVER1\infomay" 'change to suit
            If Len(Dir(sSource)) Then CreateObject("Scripting.FileSystemObject").copyfile sSource, "Z:\" 
            Application.Wait Now + TimeSerial(0, 0, 3) 
             
            On Error Resume Next 
            .RemoveNetworkDrive "Z:" 
            On Error Goto 0 
             
        End With 
         
    End Sub 
    
    
    This code works fine for me, but I am not sure you will be able to adapt for Sharepoint. Not an expert there, sorry.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  6. #16
    Join Date
    16th July 2006
    Posts
    37

    Re: Upload multiple files to sharepoint document libraries - $50

    Quote Originally Posted by Wigi View Post
    Hello

    I have written code to map a network drive. The code will then copy a certain file to the drive, and remove the mapping after 3 seconds.
    The letter Z is used to map. Please go through the code and change to suit.

    VB:
    Sub tst() 
         
        Const sSource As String = "C:\testfile.xlsx" 'change to suit
         
        With CreateObject("WScript.Network") 
             
            .MapNetworkDrive "Z:", "\\FSERVER1\infomay" 'change to suit
            If Len(Dir(sSource)) Then CreateObject("Scripting.FileSystemObject").copyfile sSource, "Z:\" 
            Application.Wait Now + TimeSerial(0, 0, 3) 
             
            On Error Resume Next 
            .RemoveNetworkDrive "Z:" 
            On Error Goto 0 
             
        End With 
         
    End Sub 
    
    
    This code works fine for me, but I am not sure you will be able to adapt for Sharepoint. Not an expert there, sorry.
    Hi Wigi,

    Thanks, I will definitely try this as soon as possible and get back to you (and happily pay you if it works).

    Excel Video Tutorials / Excel Dashboards Reports


  7. #17
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Quote Originally Posted by PATSYS View Post
    Hi Wigi,

    Thanks, I will definitely try this as soon as possible and get back to you (and happily pay you if it works).
    Hello

    Have you been able to run tests?
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  8. #18
    Join Date
    16th July 2006
    Posts
    37

    Re: Upload multiple files to sharepoint document libraries - $50

    Hi Wigi,

    I believe I have sent you all my findings thru PM?

    Anyway I did run the test and keep getting debug error in the line:

    .MapNetworkDrive "Z:", \\FSERVER1\infomay

    As I mentioned through PM, the actual sharepoint URL (copied straight from the address bar is:

    'https://sharepoint.ap.intranet.XX.co.../AllItems.aspx

    I have experimented several ways (I have listed all in my PM to you) on how to write this in a \\Server\ structure as your code suggeted but no luck - I still get the debug error message.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #19
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Hello

    I received 3 PM's on March 9, do you refer to these in particular?

    Unfortunately I cannot test this, I do not have the means to set up a Sharepoint system.

    So not sure how we can advance?

    Wigi
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  10. #20
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,063

    Re: Upload multiple files to sharepoint document libraries - $50

    Still no follow-up in this topic, while the topic poster was online some days ago.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Training: SharePoint document libraries I: Introduction to sharing files
    By Dave Hawley in forum Free Microsoft Excel 2007 Tutorials
    Replies: 0
    Last Post: December 23rd, 2008, 18:17
  2. Training: SharePoint document libraries I: Introduction to sharing files
    By Dave Hawley in forum Free Microsoft Excel 2003 Tutorials
    Replies: 0
    Last Post: December 23rd, 2008, 18:17
  3. Sharepoint Document Libraries Ii: All Checkout
    By Dave Hawley in forum Free Microsoft Excel 2007 Tutorials
    Replies: 0
    Last Post: October 23rd, 2007, 14:04
  4. Sharepoint Document Libraries I: Introduction To Sharing Files
    By Dave Hawley in forum Free Microsoft Excel 2007 Tutorials
    Replies: 0
    Last Post: October 23rd, 2007, 14:03

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
  •  
porno