Programmitically accessing WSS via Excel 2003 Data Ret

[Nock]

The only reference I could find here was an earlier post by Jay A. Ritchie.
He also was looking for a way to '..to import sharepoint data into excel
programatically.'

Can this be done?

At the moment I have a excel 2003 VBA Userform that pulls back information
from a SQL database and a WSS site. However the method I've used to pull WSS
data uses something called a .Uxdc file. Am I able to recreate this file in
VBA?

Current VBA embedded code

Worksheets("Risks").Activate
Cells.Select
Selection.ClearContents
ActiveWorkbook.XmlImport URL:= _
"\\IMMI.LOCAL\Dfs\Users\ACT\BEL2\EXBSNF\My Documents\My Data
Sources\projectserver_156 Risks.uxdc" _
, ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$1")

System Environment
Excel 2003
SQL 2003
Project Server 2003
WSS 2.0

Many thanks,

Nock (Australia)

 

[tony h]

www.wssdemo.com is a good resource for this

regards

 

[Nock]

Sorry Tony - pls ignore, an issue with my browser.

Nock

 

[Nock]

Thanks Tony...any idea how to get 'access' to the site - I can't find a
register or become a member link anywhere...

Thanks,

Nock

 

[Nock]

Thanks Tony,

I've had a good look but unfortunately I didn't find anything. Anyone else
got any resources or sample code?

Using the example below, I'm really just looking for a way to make the
'projectserver_156 Risks.uxdc' file a variable that a user can select from.

Many thanks,

Nock

 

[Jay]

Nock-

I don't think there's any other way of retrieving data from WSS lists except
through the Import External Data feature of Excel with utilizes uxdc files.
Since I need this functionality, or more specifically the ability to retrieve
data from multiple WSS lists, I'm going to create an Excel add-in to do this
using WSS's Web service interface.

The following link has code to call the Web services from managed code. It
will need to be changed to use VBA.

http://www.developerland.com/DotNet/Enterprise/253.aspx

Let me know if you're interested in my add-in and I'll let you know when
it's done.

-Jay

 

[tony h]

Just got back to this and another option may be to use ADO. There is
probably a WSS data source definition. It does to some degree, depend
on what you intend to achieve.
As for your offer please keep me up to date with your progress - it is
the sort of challenge I enjoy.
If you feel like sending me a message with your contact details please
do.

regards,
tony