VBA to upload file to Internet or SharePoint. SharePoint Automation using VBA - 8

Everything you need to know about working with SharePoint Server using VBA. Most importantly teaches you in layman's term how to use ADO, SQL in your VBA Program to manipulate data in Server.

Please like, share and comment to improve channel algorithm

You can now support by buying any of the Projects or Source Code.

📌What to watch next:

#VbaA2z

[sangu]

Thanks so much! That was extremely useful. Congrats on your VBA series.

[hoseal]

Wow excellent work! You’re channel is a hidden treasure

[samazk]

You channel is quite unique from the content plus love your simple laymen way of explaining things!

[kinwiliu]

This is just great... I wish i knew this earlier 👍👍👍👍👍 thanks

[akhapamai]

Is there a way to directly attached them to SP attachment field?

[mathiasdreke]

How can I include 2FA (two factor authentication) ? Our sharepoint server will not let me connect via FSO without proper authentication.
Maybe it's possible to do the handshake with ADO >> Send request, get response, send credentials, ....But I have no idea how to implement it.

[linnick]

I should have come across this sooner 😁 thanks

[EltonSenne]

Hi! Look likes I found a solution to an issued I've to update link fields in a SharePoint List.
I'd like to know how to upload a file to a column in a SharePoint List.
Can you help me?

[gabornyeki]

Hi ! I have two sharepoint list. How possible prepare one query with VBA?

Select * From list1, list2 Where list1.id = list2.id

Is it possible ?

[kennethho]

Hi, can I ask what is the FileNameWithExt variable for? Can we replace it with something else because I believe I have an error due to it. I have the Compile Error: Expected array

[brundan]

Is there a way to the same procedure for many times in automated way cause work allocating in this for 20+ people will be time consuming every time changing the paths of their folder

[jcelente]

Hi. I’m trying to add info in columns of created file. Is it possible? I used your tutorial for item update but I failed. Can you help me?

[RoyAliKhairan]

Hi, sir! I would really appreciate it if you could make new step by step using current SharePoint? I found difficult implementing this into current sharepoint...thank you sir!

[matthiasrauchschwalbe]

Hi VBA A2Z,
have you done this with a document library too?
Document upload works fine, but editing the metadata of these files doesnt work
cause of permitted writing rights in the DB (via SQL direct and via modifying the
result based on provider IMEX=2 and IMEX=0). Editing a list is no problem with
your code and works really fine (Thanks 4 that :-) )
with best regards

[willmarbrin]

hi! thanks for this video. Is this still working for 2022 Sharepoint?

[tingzhang]

Help me so much！Thank you for your sharing!

[Johnbond]

can we automate data into newform aspx from excel using vba

[tonynowakowski]

This has been very helpful. I've seen a this question a couple times, but is it possible with VBA to attach a document directly to the list item ("Add or remove attachments" button), rather than inputting a link?

[jvbcc]

i would like to download the code, but don't see the link. Please show my how and where
thanks a lot,
James

[yazminknepper]

Should this work for a picture library, I did try it, but not working?