filipivanovic
Board Regular
- Joined
- Oct 25, 2013
- Messages
- 54
Greetings,
I have code:
I want to insert one more row but code still need to do same thing :D
file_name = Path & "MRP_" & mat_index & "_" & mat_name & ".xls"
OR (this below is inserted line)
file_name = Path & "MRP_" & mat_index & "_" & mat_name & ".xlsx"
Is that possible?
I have code:
Code:
Sub GoTo_Material()Path = "C:\Users\rsivafil\Documents\MRP Obuka\MRP01\"
Row = ActiveCell.Row
mat_index = Range("a" & Row).Value
mat_name = Range("b" & Row).Value
file_name = Path & "MRP_" & mat_index & "_" & mat_name & ".xls"
On Error GoTo kupa
Workbooks(file_name).Activate
Exit Sub
kupa:
Workbooks.Open (file_name)
End Sub
I want to insert one more row but code still need to do same thing :D
file_name = Path & "MRP_" & mat_index & "_" & mat_name & ".xls"
OR (this below is inserted line)
file_name = Path & "MRP_" & mat_index & "_" & mat_name & ".xlsx"
Is that possible?