| 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 | |||
![Gordon Rainsford[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
