|
hello MidwestLimey,
try out following ex..
Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Try
excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open("c:\\test.xls")
excel.Visible = True
wb.Activate()
Catch ex As COMException
MessageBox.Show("Error accessing Excel: " + ex.ToString())
Catch ex As Exception
MessageBox.Show("Error: " + ex.ToString())
End Try
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
i am using vb.net 2003.i do my project in windows application.i want to send a mail from vb.net windows application.plz help me.
|
|
|
|
|
Google it[^], for the great Sage that is google has many answers to your question.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Hi,
Is there any way to re-order childs of same parent. Consider example as,
A
---1
---2
---3
Using drag drop I need to change this child order as,
A
---2
---1
---3
Any luck.
Be simple and Be sample.
|
|
|
|
|
Have you looked at this[^] example? It should you what you have to do to support doing this.
|
|
|
|
|
I'm trying to give the user a chance to confirm the userdeletingrows event after the event starts,but before the datagridview row is actually deleted.
I can not seam to quit the event without deleting the row.
I can bring up a message box and run branching logic, but I'm not sure what command will prevent the row from being deleted.
Any ideas?
Kermit888
|
|
|
|
|
Hi, I have some problem while designing a windows form application in vs 2005 pro edition. The problem occure while I drag a data grid on the form and create the column for the data grid manually.
When I run an application, an error display and told me that there is a conflic name in the designer. I do not know the real error but the column that I create in the grid named: Code, Name, Strength, Form...
When I return to the designer I found my form disappear and just display some error in the designer page. I do not know how to fix it while vs 2005 do not allow me to see my form and change the property of the control.
On the other hand, VS should inform me if there name of the column is matched with the keyword using in VS. I really feel disappoint while I challenge this problem and could not find the solution.
Does anyone have any idea about this problem? Please help me to find the solution.
Thank in Advance!!!
|
|
|
|
|
Post the error.
Tom Wright
tawright915@gmail.com
|
|
|
|
|
It because you used "Name" as column name
Try change the column name "Name" to example "Customer Name" or other name
|
|
|
|
|
Thank you very much for your help. So, how could I prevent in the future to avoid duplicate keyword with vb.net 2005?
|
|
|
|
|
I think you should read or search about vb.net keyword
GoodID
|
|
|
|
|
Thank you very much for your solution.
|
|
|
|
|
Hi, I used visual studio .net 2005 standard edition in my laptop. Vs 2005 standard do not have crystal report integrated with. So I plan to purchase crystal report v11 pro edition.
My question is, if i install crystal report v11 pro edition on my laptop, could I design a report in crystal report and integrate it with my application design in vs.net 2005 standard edition?
Thank in advance!!!
|
|
|
|
|
hi, anyone can help me figure out how to read data from a text file like this:
10980012907200228082002
and extract the data according to this kind of format:
Record type 1
TY-RECORD PIC (1).
ID-PARTICIPANT PIC (6).
DT-START PIC (8).
DT-END PIC (8).
the data can be read as ty-record = 1, id-participant = 98001, dt-start = 29072002, and dt-end = 28082002. i would want the program to extract the data and display them in a table according to their respective fields:
TY-RECORD ID-PARTICIPANT DT-START DT-END
1 098001 29072002 28082002
and to save them in an excel format. I have plenty of record types (0 - 9) and need to display them in separate tables.
does anyone has a source code for this? or at least somebody pls guide me to figure out ways to create the program.
many thanks!
|
|
|
|
|
you can read each line and replace the space with a comma, and Excel will just open it. To have multiple tables, you need to look into the visual studio tools for office.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi all
Can any one help me about how (Cut and paste files and folders from clipboard )
and i will be very thankful to everyone help me
|
|
|
|
|
can you explain some more what exactly you wanted to do ?
|
|
|
|
|
hi,
i create text file through following code
here argument FilePath contain full path of file and Data contains Contents which has been written to text file. if file already exist then it add data to previous contents of file otherwise it create a new text file
<br />
Private Sub CreateTextFile(ByVal FilePath As String, ByVal data As String)<br />
Dim oFile As System.IO.File<br />
Dim oWrite As System.IO.StreamWriter<br />
Dim oRead As System.IO.StreamReader<br />
Dim PreviousData As String = ""<br />
Dim CheckHypen As String<br />
<br />
If File.Exists(FilePath) Then<br />
oRead = oFile.OpenText(FilePath)<br />
While oRead.Peek <> -1<br />
If PreviousData = "" Then<br />
PreviousData = oRead.ReadLine()<br />
Else<br />
<br />
PreviousData = PreviousData & ControlChars.NewLine & oRead.ReadLine()<br />
<br />
End If<br />
End While<br />
oRead.Close()<br />
End If<br />
<br />
<br />
oWrite = oFile.CreateText(FilePath)<br />
<br />
If PreviousData = "" Then<br />
oWrite.WriteLine(data)<br />
Else<br />
oWrite.WriteLine(PreviousData & ControlChars.NewLine & data)<br />
End If<br />
oWrite.Close()<br />
<br />
End Sub
i don't specify encoding format . some time text file is created with ANSI encoding format and sometime UTF-8 encoding format(dependent upon content). my problem is that i strictly create file as ANSI encoding.how it is possible?
How can i set text file Encoding format to ANSI?
any help will be appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Following one line will do the all above mentioned task including appending and all ...
My.Computer.FileSystem.WriteAllText("c:\x.txt", ControlChars.NewLine & "あだsだsd", True, System.Text.Encoding.Default)
Third parameter "True" specifies appending and fourth parameter specifies ANSI depending upon ur systems ANSI code page.
|
|
|
|
|
hi prasad,
thanks for your support. i recently find method (AppendAllText) on internet during searching.i want to ask one more thing
what is the difference between My.Computer.FileSystem.WriteAllText and AppendAllText method(of system.io.file object)
can i use AppendAllText method ?
thanks in advance
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Hi Rupesh,
Ofcource you can use it. Methods in My.Computer.FileSystem provides easy to use wrapper function to use the functionality implimented in System.Io.File.
Regards
Prasad
|
|
|
|
|
Thanks a lot
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
hi
how will i get the system information and processor information using VB 6.0 codingplease help
Thanks in advance
Sathish TL
Systems Engineer
Softlution Web Technologies
Technopark ,Trivandrum
|
|
|
|
|
|
Hi,
I work on a project which takes a pdf from a database access and insert into a mysql database.
When I try to read in my program(debugging) the pdf from access and save it in a .txt file I can see the pdf but when I try to use :
File.AppendAlltext("C:\\text.pdf",mypdf)
and I try to open text.pdf it doesn't work.
All I can see is a blank page.
Please help me.
Thanks
|
|
|
|