how to get folder content or files that was in sharepoint via vba

匿名

i had removed files from local pc to sharepoint.

i had been use function "getFolder" to get files and it was success last year. but i didn't work this year.

i also looking for sharepoint api for vba and it didn't exist.

how could i use vba to get the file which was in sharepoint?

鎖定的問題。此問題已從 Microsoft 支援服務社群移轉。您可以對其是否有幫助進行投票，但無法對問題新增註解或回覆，或進行追蹤。

0 則留言

14 個回答

匿名

2023-06-01T06:41:09+00:00

You may try data>From File>From SharePoint Folder.

Could you share us your purpose to using VBA instead of Power query?
此回答有幫助嗎？

0 則留言沒有留言
匿名

2023-06-01T07:14:41+00:00

1.because i just need a cell's data which was existed in sharepoint, i think the method that you said wasn't suited to me.

2.i just found a method that excel could get sharepoint directly via vba. there are too many files and i didn't have too much time to deal.
此回答有幫助嗎？

0 則留言沒有留言
匿名

2023-06-01T07:53:20+00:00

Sync to local folder and using UNC path to get data from files.

Reference:

Get the content of a sharepoint folder with Excel VBA - Stack Overflow
此回答有幫助嗎？

0 則留言沒有留言
匿名

2023-06-01T08:28:15+00:00

it show 'Automation Error. Invaild directory'

i didn't know what it happened.
此回答有幫助嗎？

0 則留言沒有留言
匿名

2023-06-01T08:40:18+00:00

Share your VBA code and the line which get that error.
此回答有幫助嗎？

0 則留言沒有留言