macro to include cell contents b1 in file path

im trying to answer another thread and this macro does the trick but to make it easier for user id like them to be able to enter filename in say b1 and it gets added to the filepath
C:\Documents and Settings\Martin Wilson\My Documents\test stuff\filename from b1

Please Login or Register  to view this content.

other post is here http://www.excelforum.com/showthread...82#post1951782
even better would be a user form that pops up prompting for file name when macro run
pretty please

EDIT: We are having trouble with the board at the moment so i have had to reply in your post but how about this?

Please Login or Register  to view this content.