ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Generic separator (https://www.excelbanter.com/excel-programming/389710-generic-separator.html)

Gordon Rainsford[_3_]

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

Norman Jones

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




Gordon Rainsford[_3_]

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


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com