Search:

i hav used split...n here is my code......


Dim xlapp As New Excel.Application
Dim xlbook As New Excel.Workbook
Dim xlsheet As New Excel.Worksheet
Dim text As String
Dim i As Integer
Dim j...

i hav a problem.......i have an excel sheet which hav the B column values as
B1=ant & boy
B2=cat & doll etc.....
i need to split these values and paste them in C & D columns in same row.....like...

thank you for your response...well i used this...it works...

Set ftxt = fs.CreateTextFile("D:\xxx\yy.txt", True)
textperl = "initialized text"
Open "D:\xxx\yy.txt" For Input As #1
While Not...

Please can anyone suggest a good book for beginner in vb.net with solid introduction.....or any good tutorial site??
Thanks in advance.....:)

dglienna, of course i will once it works.......:)

cereal killer, yes, i asked how to call perl from vb and you gave the idea of shell....i took it up......thank you.....:)

you missed the 'if' in your answer........:)...if i would have already written it, then there was no need to ask....anyway......i found a way...lets c if it works.....

I didnt want help to modify the ip addresses....perhaps u fail to understand my query......i asked clearly how can i call a perl script from a vb program..dats all...if i hav already written the code...

how to get the contents of a text file into a variable in vb 6.0?
any help?

dglienna,well, let me explain......i need remote login to different systems to view the alarms on them....for that i hav written a perl script...now the ip addresse to login needs to be changed...

WoF, i used the code.its giving runtime error 5 invalid procedure call or argument.......

yes, i need to run it from vb only.......

i have a vb 6.0 program that creates a perl program during runtime...any idea how i can call that perl in next step??am suggested to use shell function of which i know little...how can it be...

thank you so much for your response....

Found this code in ASP file system tutorial and added it to a vb 6.0 program to write a text file during runtime.i now add the references --> microsoft scripting runtime, microsoft scriptlet library...

am getting runtime error 424-object required on the bold line of following code:

****Dim fs, fname
Set fs = Server.CreateObject("Scripting.FileSystemObject")
Set fname =...

okz....i got the solution......:D
i kept the connection instances same for oracle and access.....thanks for viewing my problem.....solved

n yes....the error is ORA-00942!! how to solve it?

Hello....:)
i connected my vb 6.0 program to ms access 2007 by the following:

**Public conn As New ADODB.Connection
Public Sub openConn()
conn.CursorLocation = adUseServer
conn.Open...

thank you cereal killer......:)

Sir, am new in job.took it so that i can learn out of it.asking, so that i can learn more about it, so that next time i need'nt need to ask anyone.anyhow, thank you.:)

Hello..
i'm assigned with a project where i've to call perl script from vb 6.0 program based on values that the vb program generates and collect the perl program values(dnt know where!!).m new to vb...