Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > General > File path/ syntax problem


Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2007, 05:44 AM
Glenvn Glenvn is offline
Freshman
 
Join Date: Jun 2003
Location: South Africa
Posts: 47
Default File path/ syntax problem


Dear all,

Here is my current code:

Private Sub Form_Load()

Dim s As String

s = Dir("C:\Documents and Settings\Test\Desktop\File\Word Documents\*.doc")

Do
If Len(s) = 0 Then Exit Do
List1.AddItem s
s = Dir
Loop

End Sub

This adds *.doc files to a listbox from my C: drive - works very nice.

NOW I would like to repeat the same code but looking on a different server i.e. Sever1

?? Syntax??

s = Dir(Server1\"D:\OBP FMS\OBP File Management System\OBP FileManagement With SQL\docs\Third Tier\BV\Forms\*.doc")

Must I use Dir or something else...?

TIA
Reply With Quote
  #2  
Old 07-17-2007, 06:01 AM
00100b's Avatar
00100b 00100b is offline
Martian In Disguise

Retired Moderator
* Guru *
 
Join Date: May 2003
Location: Minneapolis, MN
Posts: 9,566
Default

If you are mapped to that server, then use the drive-letter for that mapping.

If you are not mapped to that server but have access rights to a network-share on that server, then use the share-name. For example:
Code:
s = Dir("\\ServerName\ShareName\OBP FMS\OBP File Management System\OBP FileManagement With SQL\docs\Third Tier\BV\Forms\*.doc")
__________________
The only stupid question is the one that goes un-asked.
Reply With Quote
  #3  
Old 07-17-2007, 06:33 AM
Glenvn Glenvn is offline
Freshman
 
Join Date: Jun 2003
Location: South Africa
Posts: 47
Default

Thanx! I will try this!!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->