Y
yoram
hello,
i think this will be fairly easy but i'm not able to get it to work.
i need a macro (triggered by a hot key) to capture the full path based
on the active/selected cell in a file. for example if A1 is the active
cell in a file "ABC.xls" the the macro should save the following as a
string: "J:/mydocuments/folder1/ABC.xls/A1"
the 2nd macro when run should then take this stored string and paste
it into the new active cell.
this will useful in documenting the exact location of items we look for
across many files
searching on this group, all i have so far is:
1
Sub path()
Dim sk As String
sk = ActiveWorkbook.path
End Sub
2
Sub pathpaste()
sk = ActiveCell.Value
End Sub
appreciate any help. thanks.
i think this will be fairly easy but i'm not able to get it to work.
i need a macro (triggered by a hot key) to capture the full path based
on the active/selected cell in a file. for example if A1 is the active
cell in a file "ABC.xls" the the macro should save the following as a
string: "J:/mydocuments/folder1/ABC.xls/A1"
the 2nd macro when run should then take this stored string and paste
it into the new active cell.
this will useful in documenting the exact location of items we look for
across many files
searching on this group, all i have so far is:
1
Sub path()
Dim sk As String
sk = ActiveWorkbook.path
End Sub
2
Sub pathpaste()
sk = ActiveCell.Value
End Sub
appreciate any help. thanks.