Thanks Ron. I'm looking at that site right now. Any idea why this code
works for a folder on my machine, but not for one on a network?
myPath = ThisWorkbook.Path
ChDrive myPath '.......... <--- generates error
ChDir myPath
"ThisWorkbook" is in the correct folder on the network. I would think that
"ThisWorkbook.Path" would give me the correct string to pass to ChDrive.
"Ron de Bruin" wrote:
Hi Marcotte
See
http://www.rondebruin.nl/copy3.htm
Every second macro of each example will also work for a network path
--
Regards Ron de Bruin
http://www.rondebruin.nl