Hi Richard

You can use the path of the workbook with the macro's.

In VBA Thisworkbook.path

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Richard" wrote in message ...
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