| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
ChDrive error (server path)
ThisWorkbook.Path returns a URL type path ("\\s2\documents\...).
Thank you to everybody for your help. I copied the relevant folder onto my hard disk as a temporary fix for today, but will try Ron's and Dave's suggestions going forward. "Tom Ogilvy" wrote: ChDrive doesn't work with a URL type path. It only works with Lettered drives. So I guess it would depend on what thisWorkbook.Path returns. -- Regards, Tom Ogilvy "Marcotte A" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the true path to server (not mapped drive letter)? | Excel Worksheet Functions | |||
| Indirect does not recognize full server path? | Excel Worksheet Functions | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| How do I use a server name in an Excel chart file path? | Charts and Charting in Excel | |||
| Problems with ChDrive and ChDir | Excel Programming | |||
Threaded Mode
