Hi?
I have in a standalone Pc the following statements (working perfectly):
Dim wSht As Worksheet
Dim wBk As Workbook
Sheets(“OnHand”).Cells(5, 6) = 1
Set wBk = Workbooks(“_14KbWC126Ot.xls”)
Set wSht = Sheets(“SchedulingPanel”)
wSht.Copy before:=wBk.Sheets(“OT”)
Sheets(“SchedulingPanel”).Select
ActiveWindow.SelectedSheets.Delete
Sheets(“SchedulingPanel (2)”).Select
Sheets(“SchedulingPanel (2)”).Name = “SchedulingPanel”
Windows(“_14KbWC126Sp.xls”).Activate
Sheets(“OnHand”).Cells(5, 6) = 0
Wen I install the two Excel files in a server (Network Drive), I get the error code 9 “Subscript out of range” (because the Path is not correct) in the following statement:
Set wBk = Workbooks(“_14KbWC126Ot.xls”)
Can somebody help me and indicate to me how to define the Path in a Network Drive?
Thanks