I have a sheet which has macros to open other files and
fill them out with data.

To open the files, i specify the entire file path. The
folders are currently on a shared drive. i wish to burn
the folders and spreadsheets onto CD's. DO i have to
change the file path within VB , and what happens when one
persons CD drive is volume D: and the next is volume Z: etc

I apprecitae this is probably a simple question prased
badly, but i would appreciate your help.

Regards

Richard