Kamalteja
If the file is on a LAN drive, just define the full path. That is, if I have two users, whose LAN drive \\glbfil04\groups\custchoice maps to G:\ for one user, and K:\ for the other, writing:
will work, as long as the user has read access to the LAN and file.
If the file is on a LAN drive, just define the full path. That is, if I have two users, whose LAN drive \\glbfil04\groups\custchoice maps to G:\ for one user, and K:\ for the other, writing:
Code:
Set objWorkbook = objExcel.WorkBooks.Open("\\glbfil04groups\custchoice\Test_Data\InspectCustomer.xls")