how to get data from vb to excel [modified]

[khan2010]

Hi all anyone can help me Please i have some problem to transfer data from vb application to excel file textbox value into excel cell. i open excel file by using shell command but after open file how to add data from vb application to excell without delete or replace previouse data. here is shell coding. Dim Book1 As String Dim Directory As String Dim Program As String Directory = Book1 Program = "C:\Program Files\Microsoft Office\Office11\Excel.exe " Book1 = (Directory & "\Export") Shell (Program & Book1) Thanks for advance ___________ Khan786 -- modified at 6:56 Thursday 21st June, 2007

[Christian Graus]

The shell command is useless. You need to use the visual studio tools for office to control Excel from yuor code.

Christian Graus - Microsoft MVP - C++ "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 )

[v1i9n6o7d]

Please go through this article http://www.codeproject.com/office/BasicExcel.asp[^]which is present in CodeProject. Vinod

[khan2010]

Thanks Mr. Christian

[khan2010]

Thanx Vinod i hope that it will solved