did you try a local path instead of a server for strNowPath ?
On Friday, November 23, 2012 2:23:15 AM UTC, Teow wrote:
>
> 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, l
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
Hi Teow,
Can you ple share your Both WorkBook eg. WSO_Record.xls and the one inwhich
ur writing formula.
Regards
Prince
On Wednesday, November 21, 2012 4:34:54 PM UTC+5:30, Teow wrote:
>
>
>
> when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
> but if change to network p
Hi Buddy,
Here is your Solution, Try this instead of what you were doing before:
*amount = Application.WorkSheetFunction.VLookup
(R1C2,[Garnishment_2009_4.xls]Sheet1!R3C1:
