Browse to file and place filename in a cell

[dntel123]

Hey people,

I wrote this code a while back to browse to a directory:

Please Login or Register  to view this content.

Can anybody help me with instead of inputting the directory into cell 'C2' it puts the actual filename so for example scenario:

You browse for test.xls in C\:Desktop and this places "C\:Desktop\test.xls" in cell "c2" at the moment i can only display the path

And also if there is a way that when when u click to open the browse, if you click cancel it leaves the cell intact, at the moment it always puts a directory and overwrites, cant work it out

Thanks in advance!

[davegugg]

Just change this line of code:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Right?

[dntel123]

Yer that kinda works, if i select C:\File.doc it replaces whats in the cell with C:\C:\file.doc it adds an extra path sorta :S

[davegugg]

Try just:

Please Login or Register  to view this content.