|
-
Nov 21st, 2000, 12:11 AM
#1
Thread Starter
New Member
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
-
Nov 21st, 2000, 01:04 AM
#2
Fanatic Member
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
-
Nov 21st, 2000, 01:49 AM
#3
Fanatic Member
VBKNIGHT, please format your code like this:
[code]
code goes here
[/code]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|