Excel VBA (under Citrix) issue How to read a list of files on SharePoint

[Keebellah]

Hi guys,
I'm stuck with the following problem.
I've got a working Excel application for when it comes to local folders or network folders but now I what to get to work using SharePoint.
The Excel Application is opened in Excel (not browser) so all VBA is active and works as goes to opening the file and initializing the only problem is that I cannot get it to list Excel files

I've checked out many routines but is always tells me that the path is recognized of after a long timeout incorrect path or connection.
With the initial h t t p s etc it stops immediately telling me that the pas is invalid or doesn't exist

If I remove the initial h t t p s colon then it waits and finally returns an error that it cannot find the folder (it exists and I can open it when logged into the environment)

Global Const mySharePointRoot As string = "https://connect.somesitename.de/somefolder/anotherfolder/WOW/Shared%20%20documents/Projectdocuments%20vanaf%20sept%202019/Janis/"
Global Const myFolder As String = "Excelfiles\"

Public Sub ListFiles()
    Dim folder As folder
    Dim f As File
    Dim fs As New FileSystemObject
    Dim RowCtr As Integer

    RowCtr = 1
    Set folder = fs.GetFolder(mySharePointRoot & myFolder)
    For Each f In folder.Files
       Cells(RowCtr, 1).Value = f.Name
       RowCtr = RowCtr + 1
    Next f
End Sub

No spaces in any value and if I replace all the forward slashes with back slashes or vv, no difference.

Any suggestions?

Mapping the folder to a driveletter doesn't work either (probably because of the Citrix Environment) I have to work with as weel as the user I'm trying to help

Any help or tips will be appreciated, my best friend Google has not given up the Eureka solution either (yet)



P.S. I've posted the same question here: https://forums.techguy.org/threads/e...point.1249916/