?
Solved

reading text file

Posted on 2003-02-28
6
Medium Priority
?
151 Views
Last Modified: 2010-04-07
Hi,
I have text file in windows2000 server.Can I read this file from a windows2000 professional by passing the user id and password in an open statement.
In my VB application I am using Filesystem object.
Cheers
0
Comment
Question by:shaji_am
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 18

Accepted Solution

by:
Sethi earned 200 total points
ID: 8041157
Set References to Microsoft Scripting Runtime in your VB project.

Declare the following variables in Declaration section:
     Dim objFSO As FileSystemObject
Dim objTextFile As TextStream
Dim strRead as String
     
Create the following Sub to Write to a textfile:
Public Sub WriteToFile()
     strFileName="C:\My Documents\Testing.txt"
         Set objTextFile = objFSO.OpenTextFile(strFileName, ForReading)
strRead = objTextFile.ReadAll
End Sub
'--- strFileName is the file name where you want to write the text along with the full path of the file.
0
 
LVL 16

Expert Comment

by:twalgrave
ID: 8050019
shaji_am,

You have been asked to maintain your open questions previously and have failed to do so.
You have 8 opened questions as of this date.  
I will be posting in each of these questions older than a month.  
Please take care of your opened questions older than 30 days by clicking on your logon name link and looking for UnlockedQ or using the links I am providing below.  
Please finalize these within 72 hours or I will ask administration to look into your account at that point.  
If you have questions, please ask and I will provide assistance.  

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20340207.html
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20247782.html
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20117484.html
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20117472.html
http://www.experts-exchange.com/Programming/Programming_Languages/MFC/Q_20105806.html
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20375340.html
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20324261.html

Thank you.
0
 

Expert Comment

by:CleanupPing
ID: 8900985
shaji_am:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
 
LVL 16

Expert Comment

by:twalgrave
ID: 8903998
recommendation: answered by Sethi
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 9001639
Moderator, my recommended disposition is:

    Accept Sethi's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month13 days, 4 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question