Opening Excel file from vb

[WP]

I need some help.

I have the following:

sFilename = GetXLFile()

On Error Resume Next

Set mXL = GetObject(, "Excel.Application&quot 'look for a running copy of Excel
If Err.Number <> 0 Then 'If Excel is not running then
Set mXL = CreateObject(&quot;Excel.Application&quot 'run it
End If
Err.Clear ' Clear Err object in case error occurred.

On Error GoTo 0

Set mXLWbk = mXL.Workbooks.Open(strFilename)

Problem is I need to have the file open in edit mode and not just in the background. Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[mymou]

Will this do?

mXL.Visible = True

Stew