Internet/intranet approach

[Bart]

Hello,

I'm trying to approach an intranet directory in order to determine which
files are in it. For this purpose I've already tryed the 'Searchfiles.lookin'
and Dir() functions but both don't accept the "http://-directory-" - format.
Seacrhfiles doesn't accept anything BTW. Only his own format and an empty
string....

Can anybody help me out here?

Bye,

Bart

 

[Russ]

Bart,

Hello,

I'm trying to approach an intranet directory in order to determine which
files are in it. For this purpose I've already tryed the 'Searchfiles.lookin'
and Dir() functions but both don't accept the "http://-directory-" - format.

Microsoft Word is not a World Wide Web browser which uses the http:// prefix
as far as I know. Are you trying to search for *.htm or *.html files?

For something on your computer use file:// prefix or standard C: drive, etc.
prefix

A local area network LAN might use something like \\domain name\user name\C:
drive

 

[Bart]

Hello Russ,

Thanks for your replay, but as you can imagine, it isn't the answer I'm
looking for...

My employer works with Sharepoint, this is an internet based program. It can
be used as a kind of work-area for taskgroups etc.. It is also a sort of
database. And this is my 'problem'; this database has to be checked once in a
while. Through the name of the document I can see if the document has to be
checked or not.

The solution I've thought about was to not check Sharepoint, but the
archive. The disadvantage of this is that it isn't guaranteed synchronic, if
you know what I mean.

Greetings,

Bart

 

[Jezebel]

Wishful thinking is not going to change the answer. Dir() looks at your file
system. It doesn't talk to the server.

 

[Bart]

I was afraid for that.
If I have it clear; VBA is not able to approach an inter/intranet adres at
all?

 

[Cindy M.]

Hi =?Utf-8?B?QmFydA==?=,

My employer works with Sharepoint, this is an internet based program. It can
be used as a kind of work-area for taskgroups etc.. It is also a sort of
database. And this is my 'problem'; this database has to be checked once in a
while. Through the name of the document I can see if the document has to be
checked or not.

I suggest you ask in a group dedicated to Sharepoint. I'm sure they can give you
some pointers...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Jay Freedman]

I think you'd get better answers by posting in the newsgroup
microsoft.public.sharepoint.windowsservices.development -- through the
web portal,
http://www.microsoft.com/communitie...g=microsoft.public.sharepoint.windowsservices

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Bart]

Thank you Jay and Cindy!
I hope they can help me out there!

Bye,

Bart

 

[ben h]

SharePoint is set up to provide most of its info via its web services.
See for reference:
http://www.developer.com/tech/article.php/3104621
http://weblogs.asp.net/jan/archive/2004/02/04/67218.aspx
microsoft.com/sharepoint

Your VBA project can reference the Microsoft WinHttp services library,
which is a pretty simple provider of http services.
For talking to sharepoint via web services however, VBA is not the best
environment for playing. You'll have much more fun with .NET, upon which
SharePoint and its components are built.

For checking the SharePoint database (SQL Server) you can do this
directly via OLEDB if you know the database and have some connection
info, and if you know where to look. I don't

Ben

 

[Bart]

Thank you!
Unfortunately I only have VBA and I'm sure that I don't get VB.Net on my
system. This, as a result of a bureaucratic management, which I have accepted
in the last couple of years...
However, thanks again. I have, as I've wrote in my last message, an solution;
The user have to select all the files via the 'open dialog box'. This is how
I can read the filenames in Sharepoint. I know it isn't a decent solution,
but I have reased my goal, knowing there isn't an other option.

Bye,

Bart