Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
define relative path from xls to xml file
Hi All,
i have an excel-project with a separate xml file where config information is stored. this xml is reference through a public constant with an absolute path, like that: Public Const strXMLFile As String = "D:\Documents and Settings\t119637\Desktop\xls_work\Config\config.xm l" This works as long as the xls file runs on the machine where this absolute file path is existing. If i'd like to move these files (the excel file with the vba code and the xml file) to another machine where this path is not existing, the excel sheet wont work cause the xml file is not found. Is there a ways to define a relative path to the xml file startin from the actual xls file? E.g: the excel is stored in: xls_work/myFile.xls and the xml file is stored in xls_work\Config\config.xml So i would assume that the vba code needs to determine what the path to the xls file is and add a /Config/config.xml to that path to have the xls file work with the settings in the xml file. I dont know the vba code that makes this possible help woul be greatly apreciated regards thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
define relative path from xls to xml file
Hi Thomas,
Seeing that you haven't received any responces as of yet, the only relative path I know of is Application.Path, which returns the directory that the Excel application is stored in. But that would mean you'd have to store your files off of Excel's application path. Another "out there" idea is to load the relative-portion of the path from a text file. HTH Trent Argante [DC.J(n/a)] " wrote: Hi All, i have an excel-project with a separate xml file where config information is stored. this xml is reference through a public constant with an absolute path, like that: Public Const strXMLFile As String = "D:\Documents and Settings\t119637\Desktop\xls_work\Config\config.xm l" This works as long as the xls file runs on the machine where this absolute file path is existing. If i'd like to move these files (the excel file with the vba code and the xml file) to another machine where this path is not existing, the excel sheet wont work cause the xml file is not found. Is there a ways to define a relative path to the xml file startin from the actual xls file? E.g: the excel is stored in: xls_work/myFile.xls and the xml file is stored in xls_work\Config\config.xml So i would assume that the vba code needs to determine what the path to the xls file is and add a /Config/config.xml to that path to have the xls file work with the settings in the xml file. I dont know the vba code that makes this possible help woul be greatly apreciated regards thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Relative path for XML data file? | Charts and Charting in Excel | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
define a database path | Excel Programming | |||
relative reference in a macro to define a name | Excel Programming | |||
how shall i define the path when using export? | Excel Programming |