Excel Relative Path

[MissingLink]

Hi there

I am busy using an existing Excel workbook to generate quotes, but at the moment the path to the workbook is absolutely referenced.

Dim wb As Excel.Workbook = excel.Workbooks.Open("C:\Users\Bob\Documents\Visual Studio 2008\Projects\Quoter\bin\Debug\Quote.xls")

How do I use relative referencing on this?

 

[JohnH]

Relative to Documents folder?

Dim absPath As String = IO.Path.Combine(My.Computer.FileSystem.SpecialDirectories.MyDocuments, "subfolder\file.ext")

 

[MissingLink]

Preferablly want the document to exist in the application folder.

 

[JohnH]

Preferably you should then use the designated application folders to store data files, ie one of these:

Application.CommonAppDataPath 
Application.LocalUserAppDataPath / Application.UserAppDataPath