Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generic separator
I'd like to construct a path name by adding a filename to a directory
path, such that it works whatever platform it's being run on. ie I need to know what to use as the separator so that it puts in a "\" on a PC & a ":" on a Mac -- Gordon Rainsford London UK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generic separator
Hi Gordon,
Try using: Application.PathSeparator --- Regards, Norman "Gordon Rainsford" wrote in message news:1hyeqip.nqw2ka1wt61blN%grbridgeREMOVETHIS@bti nternet.com... I'd like to construct a path name by adding a filename to a directory path, such that it works whatever platform it's being run on. ie I need to know what to use as the separator so that it puts in a "\" on a PC & a ":" on a Mac -- Gordon Rainsford London UK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generic separator
That worked - thanks. Norman Jones wrote: Hi Gordon, Try using: Application.PathSeparator --- Regards, Norman "Gordon Rainsford" wrote in message news:1hyeqip.nqw2ka1wt61blN%grbridgeREMOVETHIS@bti nternet.com... I'd like to construct a path name by adding a filename to a directory path, such that it works whatever platform it's being run on. ie I need to know what to use as the separator so that it puts in a "\" on a PC & a ":" on a Mac -- Gordon Rainsford London UK -- Gordon Rainsford London UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use 100 separator inspite of 1000 separator in excel | Excel Worksheet Functions | |||
Generic Form | Excel Programming | |||
Generic n in For n To xxxxx | Excel Programming | |||
Generic Macro | Excel Programming |