[pelizdr]

Let me preface this as I am a "cut and paste" programmer. I have mountains of respect for those that can sit and write code from scratch, my brain is just not wired that way...

I am working on a project to import data from a SharePoint website into SQL. The data is in a Sharepoint library. I can access the library directly from a url as well as from Windows Explorer (cannot map a drive however, XP is being finicky) using Network Places.

I have an existing chunk of code that pulls a list of Excel files from a specific location (\\domain\dfs\folder) into the list box. All I am trying to do is change the path (vb.listbox path) to http: (http://mysharepoint/folder names with spaces/folder I need to pull data from) If I enclose the http: string in quotes, I get path not found. Any help would be greatly appreciated!

[Neku]

two things:

1) with all respect, this is not a coding giveaway forum.

2) you should in the very least post the code you tried otherwise it will be much harder to help you

[pelizdr]

I wasn't expecting anyone to "give away" code, I can just Google that .

Listbox on form is labeled ICAM_File, I am trying to populate the Listbox, setting the ICAM_File.Path property to an HTTP: location...

This is what the line of code looks like that works, going to a drive letter:

ICAM_File.Path = "C:\open"

or going to a UNC:

ICAM_File.Path = "\\myshare.domain.ou.com\dfs\Quarterly Leased Assets Report"

When I attempt to change the value to "http://server.com/Sharepoint site/blah blah/", I get path not found. I have access to the path on SharePoint where the file resides, so I am assuming there is some limitation to the Path property.

What I am asking is: Can you use an HTTP address for the path property, or is there a different Listbox property that can be used to assign the http link?