Hi,

i have been trying to copy a specific range of cells from multiple files. I have been looking through and found some code that acheived this which works for files in a directory.

The files i need to read i on a sharepoint site though so the directory structure has changed from C:\CT\Files to http://incateams/sites/teamcaddy/blending/Blending Documents

The code i have will not read the files that i need to do this once i have changed the slashes to the opposite way around.

Can anyone give me a heads up in which direction i shoul dbe looking?


Thanks ;-)