Update file path's month using VBA code.

[outlawdevil]

I must have done something wrong with my code I want to update file path's month but I couldn't get it to take my code. I got a compiling error Can someone take a look? Thanks.

Change C1 value based on C2 list. Hopefully if anyone could add a code to active this cell as link. Thanks.

Sub changemonth()
Dim ws1 As Worksheet
Set ws1 = Sheets("sheet 1")

range("C1").Value="C:\Users\cooll\Desktop\Lease Agreement\ & Text("C2",text) &"\week1\"

End Sub

 

[cooper645]

You were missing a " after lease agreement\

Dim ws1 As Worksheet
Set ws1 = Sheets("sheet 1")

Range("C1").Value = "C:\Users\cooll\Desktop\Lease Agreement\" & Text("C2", Text) & "\week1\"

End Sub

 

[outlawdevil]

Awesome! Thanks!