Jet_Fixxxer

Here is what I'm trying to do.  I know it's pretty easy but I'm very very green to VB.  Just getting the information I need from Books, VBCODE.COM and using help.  I'm "Trying" to make a program and when I click on tool bar function it opens up Excel.  I have that down but what I want to do it open a specific Excel file from a network drive.  I'm having a hard time find the code for to do this.  I pretty sure it's not opening up a specific file because it's not map.  Here is what I have.

Shell("C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE", vbNormalFocus & "X:\\DSM-G600\HDD_a\...\....xls)

 



Re: Visual Basic Language Connecting to a network drive.

DMan1

As long as Excel is properly registered on the runtime machine and the network drive is mapped and connected the following will work:

Process.Start("X:\DSM-G600\HDD_a\TheFileName.xls")






Re: Visual Basic Language Connecting to a network drive.

Jet_Fixxxer

Thank You that worked.