Download/Upload Excel files from/to Sharepoint by Macro

[nihhalmca]

Hi All,

I need to write Macro for

1. Have to Download files from Sharepoint (url: http://sharepoint.............)

2. Then have to Upload files into Sharepoint (url: http://sharepoint..........)

Could you please assist with VB script.

Thanks,

Nihhal.

[jagan]

Hi Nihhal,

You can make a shared drive of your sharepoint in your machine or server, so that you can read directly from that folder instead of downloading, also you can copy your files to that folders easily.  Check with your sharepoint team.

Regards,

jagan.

[nihhalmca]

Hi Jagan - Thanks for your response. we have some issues to create share drive.

Could you share VB script for downloading and uploading if possible please.

[jagan]

Hi Nihhal,

I never tried this, but you can below link hope it helps you.

VBA Code to Upload/Download Files to/from sharepoint Library. -

VBScript to Upload file to SharePoint DocLib - Stack Overflow

[nihhalmca]

Hi Jagan - not working.

I have found for downloading files, can you help with uploading files please.

[MK9885]

[VB6] Using WinInet to post binary file | IT blog

rest - How to upload a file from a sheet (via VBA macro) to a laravel application? - Stack Overflow

[jagan]

No idea Nihhal, Google it and find it.

Regards,

Jagan.

[nihhalmca]

Hi Jagan, do you have any idea about below error its related to macro.

Set objPC = WScript.CreateObject( "WScript.Network" )

This code is not executing in qlikview application. (when i click "check" buttion this is highlighting).

Thanks,

Nihhal.

[jagan]

I am not sure.  Check this link may be you will get some info.

Regards,

Jagan.

[nihhalmca]

Hi Jagan - I could not find link in your post.