any idea?
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not b
Both files in same server, but I wish can add the path but use a cell value
in worksheet "Data_Set" on the Publish.xlsm file
Below blue color script is a new add modify, but still come out error 1004
C2 = \\Server\Plan Delivery
D2 = [WSO_Record]Record
Private Sub Worksheet_Change(ByVal Target As
both files is under same server, but if i want set give a path value in
Publish.xlsm,
in worksheet "Data_Set", C2 is path and D2 is target file and sheet name to
connect
the blue color script if i add will solve the issue?
C2 = \\Server\Plan Delivery
D2 = [WSO_Record]Record
Private Sub Workbo
thx your reply, here is the excel file, is use Publish.xlsm connect
WSO_Record.xls
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
but if change to network path " & ThisWorkbook.Path &
"\[WSO_Record.xls]Record, i will get error 1004, what is the error in my
script?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Ta
