| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Sharepoint site & Determine the number of files and their nam
I am trying to open a sharepoint site and "process" all of the files in it.
Specifically to set their connections. Problem is that I cannot seem to use the folder like I can on a LAN drive. My code is: strPath = ActiveWorkbook.Path Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder(strPath) If I have the activework book on a LAN drive then no problems, but it appears that using the CreateObject part on the Sharepoint site does not see the path the same. Can anyone help me determine if I'm using the object wrong or perhaps not the correct one? Thanks in advance. Scott Elrod |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wht can't I open Excel files from Sharepoint any more? | Excel Discussion (Misc queries) | |||
| Accessing Excel Documents on a SharePoint Site | Excel Programming | |||
| VBA Code to open an Excel file on a sharepoint site | Excel Programming | |||
| Possible to import data from spreadsheets on sharepoint site? | Excel Discussion (Misc queries) | |||
| Can a Macro open workbooks on a SharePoint Site? | Excel Discussion (Misc queries) | |||
Threaded Mode
