Programing a drive as a variable

[gde]

I'm trying to update a macro. the program prints a series of excel sheets
from a directory in a network drive, the code has been shared with other
offices that have a different arrangement in their directory tree, since
the code refers to the specific drive we have, the macro does not work.

I want to have the user find the folder on his/her computer with a browse
button; that can explore the computer, any ideas?.

 

[Robin Hammond]

Have a look here

http://www.j-walk.com/ss/excel/tips/tip29.htm

 

[gde]

Thanks, I'll try it today, I'll get back to y'all with errors or any more
questions.