I am trying to convert my dad's lotus spreadsheets to excel 2003. I am a noob to visual basic and will be asking some relatively easy questions. Here is the first.

He has a lotus macro activated by CTRL "L" keys that combines a file from a specific directory on disk (/fcce in old style lotus). The filename is entered into the acive cell. How do i get the cell contents into the vb file request? The contents can be anything as long as it is a valid filename. Also is there a second variable that can be used in case the file is stored on a usb drive to be carried to vaious job sites and computers, or if the computer has more than just a c: drive. The current drive letter is also on his spreadsheets as is a working directory name.