I'm trying to access a file, but can't do it with a relative path.
If I use an absolute path, e.g.
excelFileSource = "C:\\My Documents\\myDirectory\\my
then it works, but I need to do it with a relative path.
How can I accomplish this?
Dim excelFileSource As String
excelFileSource = "myDirectory\\myFile.xls"
Set excelApplication = GetObject(, "Excel.Application")
If Err = 429 Then
Set excelApplication = CreateObject("Excel.Application")
Set excelWorkbookSource = excelApplication.Workbooks.Open(excelFileSource)