Path not found when using a URL

[WaterGypsy]

Hi everyone

I am trying to access files on our sharepoint system so that I can update a dashboard showing when they were last run.

I can open a file held on sharepoint if I specify the full path and name, but if I try to access the folder only, so that I can list the files stored in that folder I get "Path not found".

I have tried objFSO.GetFolder and even simply ChDir (which works when I'm recording macro but not when I run that macro afterwards).

I don't even know where to look any more (

Thanks in advance for any assistance

Kevin

Forgot to say that the sharepoint address starts http:..... (obviously?)

 

[Gary McMaster]

Hi Kevin,

Just a guess:

Maybe setting the "Hyperlink Base" will work?

ThisWorkbook.BuiltinDocumentProperties("Hyperlink Base") = "... Your Path Here ..."

You can also access the "Hyperlink Base" from the GUI in properties dialog box.

Gary

 

[Ruddles]

Are you saying you can open a file held on sharepoint via its URL (http://) using the File System Object?

If so, that surprises me. (I freely admit to knowing nothing about SharePoint but I have set up Web servers and Web sites in the past.)

I would have though that in order to use FSO to get to the folder, you need to reference it by its full path name, i.e. to pass the request to the filing system rather than the Web server.

Can you post your code?

 

[WaterGypsy]

Sorry Ruddles, I may have inadvertently misled you ....

I can open the file normally using

Public Const sTimeSheetFilePath As String = "http://sharepoint.xyz.com/Management/Internal Dashboard/TimeSheets yyyymmdd.xlsx"

Workbooks.Open Filename:=sTimeSheetFilePath

My problem is that there may be several files in the folder with different dates, I want to be able to loop through and select the most recent file for processing.

I can do it using "Dir" where the path is a local or shared drive but not where the folder is addressed using "http:"

 

[WaterGypsy]

Gary ... that didn't work I'm afraid - still get "Path not found"

 

[Ruddles]

And you don't know the actual path to the folder? I mean, you can't get to it via the Windows filing system UNC - \\server\path?

 

[WaterGypsy]

And you don't know the actual path to the folder? I mean, you can't get to it via the Windows filing system UNC - \\server\path?

Nope ... not as far as I know ... but you have given me an idea .....

 

[WaterGypsy]

... which didn't pan out ..... but in looking at the problem with a colleague I realised that the sharepoint pages may not be folders in the strict sense of the word - they appear to be web pages that act like folders so need to be treated differently.

Thanks for the input folks

 

[MikeDBMan]

Did you ever figure out how to get a listing of files on a SharePoint path? I too am needing to do that. Thanks.

 

[WaterGypsy]

Sorry Mike I couldn't but I did think that maybe because it isn't a pure directory that was the reason I couldn't use the normal methods