如何使用VBA读取安全的sharepoint目录？

I’m trying to write a macro to connect to an https sharepoint directory and read the list of files contained within the directory (so that I can parse the filenames and then open the appropriate one and read some data from it).I’m trying to write a macro to connect to an ht