I've just started learning VB6 so this may seem simple but I don't understand it. The following code is supposed to open an XL file and make a simple change to C1. What I have found is that the task manager shows that the XL process continues after the subs' completion. This only happens when the line of code making the change is included... without it everything is fine. Any assistance would be welcome. Dave
[VBA]
Sub Fxchart()
Dim objExcel As Object, objWorkBook As Object, Rng As Range
Set objExcel = CreateObject("EXCEL.APPLICATION")
Set objWorkBook = objExcel.Workbooks.Open("C:\chartf(x).xls")
'problem below
[sheet1!C1] = Application.InputBox("Input iteration")
Application.DisplayAlerts = False
objExcel.Quit
Set objExcel = Nothing
Set objWorkBook = Nothing
Application.DisplayAlerts = True
End Sub
[/VBA]