how do i open, read and write to individual cells for microsoft excel in visual basic.
where do i get information on how to do so.
thanks
Liam
Printable View
how do i open, read and write to individual cells for microsoft excel in visual basic.
where do i get information on how to do so.
thanks
Liam
Hope this will help...
Sub NewApp()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
With xlApp
'u can use vba code here like
Range("A1").Select
ActiveCell.Value = "VBKNIGHT"
ActiveCell.Offset(1, 0).Activate
ActiveCell.Value = "VBKNIGHT"
End With
xlApp.Quit
End Sub
VBKNIGHT, please format your code like this:
[code]
code goes here
[/code]