One way to do this is to write a subroutine in your Excel spreadsheet that
takes either an object or variant as a parameter, convert the object to a
string array and input your values from the array into the range that you
wish. I've done this in VB6 but not .NET. It looks like it should work in
..Net as well. Just include a reference to the Microsoft Excel Object library
(whatever version that's on your machine and the target machines). Then do
something like this:
Dim o As Excel.Applicati on
Dim xsheet As Workbook
Dim myArray(5) As String
' is Excel already open?
o = GetObject(, "Excel.Applicat ion")
' if not, open it
If o Is Nothing Then
o = CreateObject("E xcel.Applicatio n")
End If
For i As Integer = 0 To myArray.GetUppe rBound(0)
myArray(i) = i.ToString()
Next
xsheet = o.Workbooks.Ope n(FileName:="so mefilenameandpa th")
xsheet.Applicat ion.Visible = True
' run the subroutine you want
xsheet.Applicat ion.Run("Routin eName_FileRange ", myArray)
HTH
Steve
<mi*********@bi gpond.comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
Can anyone help me. I wish to export an array from vb.net to excel
ranges. This will happen for multiple files. The ranges names will not
be start and end in the same cells on all files. How do i do this?
