raccoon588
Board Regular
- Joined
- Aug 5, 2016
- Messages
- 118
Is there a way to have the path = a cell in the workbook
something like =range("setup-lamp types!I1")
the above doesn't work, so is there another way?
something like =range("setup-lamp types!I1")
the above doesn't work, so is there another way?
Code:
Sub Save1()
Dim nom As String
Dim path As String
path = "\\hinas1\mfg\S8WData\Christine Myhaver"
nom = ThisWorkbook.Name