Linking VB TO EXCEL
Linking VB TO EXCEL
(OP)
I just started using visual basic and I want to know how to link Excel with visual basic. I created the interface already...I jus need help wit the coding.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Linking VB TO EXCEL
M777182
RE: Linking VB TO EXCEL
CODE
Set myXL = GetObject(, "Excel.Application") 'look for a running copy
If Err.Number <> 0 Then 'If Excel is not running then
Set myXL = CreateObject("Excel.Application") 'run it
End If
Err.Clear ' Clear Err object in case error occurred.
On Error GoTo 0 'Resume normal error processing
myXL.Workbooks.Open ("c:\j3.xls") ' Your full path
myXL.Visible = True ' or False if you're just processing
myXL.Worksheets(1).Range("J1").Value = "fred" 'set value
lngInput = myXL.Worksheets(1).Range("H2").Value ' get
To close when you're finished:
CODE
For Each W In Workbooks
W.Close savechanges:=False ' or True as reqd
Next W
myXL.Quit
Set myXL = Nothing
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Linking VB TO EXCEL