Member Avatar for Loveleenah

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

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.