Get Web Folder List of Files

[lorveney]

Hi All,

I currently have an Access VBA module that browses for a folder name using Getfolder (SHBrowseForFolder function), then gets a list of all the Excel files in the chosen folder using Dir(folder & "\*.xls") and opens and processes each file in turn using Excel Automation.

Can anyone tell me how I should adapt this for Web folders? Should I be using WebDAV or a modified SHBrowseForFolder or something else?

Access/Excel versions used are 2002 (XP). I can open and load/import files from the webfolder using the standard menus in Excel/Access so the basic software is there.

Many thanks

 

[KeithG]

Check out the FileSystemObject

 

[lorveney]

What I want to be able to do is allow the user to browse through the sharepoint folder structure and select the folder they wish to process. Then using the selected folder, process each of the Excel files it contains one by one. This is what the Getfolder (SHBrowseForFolder function) currently allows me to do with the standard filesystem. I cannot, however, make it work with web folders.

 

[lorveney]

Further to this, when I use:

xxx = Dir("C:\Myfolder\*.xls")

I get the name of the first Excel file in the C:\Myfolder directory.

What is the equivalent command I should use to get the same from the web folder Myfolder on http://xxx.uk.yyysrv.net/ParentFolder/MyFolder