2 Replies - 911 Views - Last Post: 31 July 2012 - 10:27 AM Rate Topic: -----

#1 pelizdr  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 14-December 09

VB6 populate Listbox from Sharepoint Library question

Posted 26 July 2012 - 04:27 AM

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!

Is This A Good Question/Topic? 0
  • +

Replies To: VB6 populate Listbox from Sharepoint Library question

#2 Neku  Icon User is offline

  • D.I.C Regular

Reputation: 20
  • View blog
  • Posts: 268
  • Joined: 21-May 09

Re: VB6 populate Listbox from Sharepoint Library question

Posted 26 July 2012 - 07:45 AM

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
Was This Post Helpful? 0
  • +
  • -

#3 pelizdr  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 14-December 09

Re: VB6 populate Listbox from Sharepoint Library question

Posted 31 July 2012 - 10:27 AM

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

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?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1