Upload multiple files to sharepoint document libraries - $50

[Wigi]

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

[PATSYS]

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

[Wigi]

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.

[PATSYS]

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

[Wigi]

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.

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.

[PATSYS]

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.

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).

[Wigi]

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?

[PATSYS]

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.

[Wigi]

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

[Wigi]

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