Loop through files in sharepoint folder

[kubabocz]

Hi all,

I am trying to put together a macro but can not make it work. I've looked online and tried many codes that I've found but unfortunately couldn't make them work. Maybe you will be able to help and explain how it should look like. I will not paste any code here as basically I've used about 8 different one and they didn't work so no idea what to include here.

I want macro that will:
1. Open each file in sharepoint folder http://sharepoint.demant.com/sites/ProjectManagement/Pages/default.aspx?RootFolder=%2Fsites%2FProjectManagementOfficeDGSOperations%2FSPOPMO%2FSPOGlobal%2FGlobalOPS%2FGlobal%20SPO%20Project%20folder%2FzzzFilesForPmTool&FolderCTID=0x01200097A770A55FBA7C4AAE8F7D461CF0AE21&View=%7BC08B17D6%2D7A23%2D4511%2DBD82%2D0E7C07DCB639%7D
1a. Take under consideration that when I open the files in this folder I get a pop up window saying that they can not be opened in browser and they ask if want to open in excel instead, so I need to click "Open in Excel" for them to work.
2. Do some actions - I can write that part
3. Close the opened file
4. Open next one etc.

Thank you