HI, I want to open a file whcih is kept on one server. File should open when i click on check box
I am using the code

Private Sub Check1_Click()
Dim xlTmp As Excel.Application

Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open filNam
End Sub
Code is working fine but the file is not getting opened.
Can anyone pls help.
Thanks in advance,
Loveleen

Well, if it is being opened over a network it will take time. You will need to check your object to see if you were successful, or you could copy the file locally and then open the file, do your thing, and then copy it back.

Good Luck