read/wright

[starcraft]

How do i have VB.net either wright a file that it can read and edit or create a Excel Spread sheet that it can read and edit?

 

[Iceplug]

Check out the StreamWriter

Dim SW As StreamWriter = File.CreateText("C:\test.txt")
SW.WriteLine("Hello There!")
SW.Close

Doing an Excel Spreadsheet requires you to use the Excel libraries and functions.

 

[starcraft]

o cool thanks for the help how would i search and remove items from the file?

 

[starcraft]

and it says StreamWriter is not defined

 

[Iceplug]

System.IO.StreamWriter is the full name.
You can import System.IO as well.
For removing items from the file, you need to use System.IO.StreamReader to read the file, determine if you want to keep this line, and, if you do, write it with the System.IO.StreamWriter

 

[starcraft]

i cant find system.IO in the reference screen where can i find it?

 

[Iceplug]

I dont have an IDE for VB.NET, but you should just be able to add

Imports System.IO

to access the IO.

 

[starcraft]

hmmm this IO thing just isnt working for me, though nothing ever does but when i put either

system.IO.StreamReader

or

 IO.StreamReader

i get

C:\Documents and Settings\Michael\My Documents\Visual Studio Projects\AutoComplete\Form1.vb(95): StreamReader is a type in IO and cannot be used as an expression.

 

[Iceplug]

Did you declare a variable for StreamReader or can you not get either StreamReader or StreamWriter to work.

Imports System.IO
...
Dim SR As StreamReader = File.OpenText("C:\test.txt")
Dim SW As StreamWriter = File.CreateText("C:\test2.txt")
Dim S As String
S = SR.ReadLine()
SW.WriteLine(S)
SR.Close()
SW.Close()

 

[starcraft]

stringwright works so ill try what u just posted thanks for the help

 

[starcraft]

when i do that code both the Stringread and wright wont work, they are underlined in blue saying that they are not defined

 

[starcraft]

OOPS sorry i figured it out i started a new project and forgot to import sorry