topic Re: Download/Upload Excel files from/to Sharepoint by Macro in QlikView

Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Download/Upload Excel files from/to Sharepoint by Macro

jagan — Thu, 08 Dec 2016 03:27:32 GMT

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.

Re: Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Thu, 08 Dec 2016 05:09:49 GMT

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.

Re: Download/Upload Excel files from/to Sharepoint by Macro

jagan — Thu, 08 Dec 2016 05:44:14 GMT

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

Re: Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Mon, 12 Dec 2016 15:30:57 GMT

Hi Jagan - not working.

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

Re: Download/Upload Excel files from/to Sharepoint by Macro

MK9885 — Mon, 12 Dec 2016 15:38:09 GMT

[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

Re: Download/Upload Excel files from/to Sharepoint by Macro

jagan — Tue, 13 Dec 2016 02:57:06 GMT

No idea Nihhal, Google it and find it.

Regards,

Jagan.

Re: Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Thu, 15 Dec 2016 07:48:54 GMT

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.

Re: Download/Upload Excel files from/to Sharepoint by Macro

jagan — Thu, 15 Dec 2016 08:08:10 GMT

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

Regards,

Jagan.

Re: Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Thu, 15 Dec 2016 08:13:09 GMT

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

Re: Download/Upload Excel files from/to Sharepoint by Macro

jagan — Thu, 15 Dec 2016 08:20:24 GMT

Sorry missed it.

Wscript.Network – Notes From The IT Shop (Not in the field anymore)

Re: Download/Upload Excel files from/to Sharepoint by Macro

nihhalmca — Thu, 23 Mar 2017 11:51:50 GMT

Finally i resolved it. I could not add macro here.

you can google it for download and upload macro. only change here that use unc path in upload script.

Thanks

Nihhal.

Re: Download/Upload Excel files from/to Sharepoint by Macro

vardhancse — Thu, 23 Mar 2017 12:13:15 GMT

Hi,

can please let us know the solution, even I am looking for the same type of requirement.