Change RunCode path to same folder as Access DB (Code snippet included)

[LNG2013]

Hello,

I have a button in Access where when clicked it opens an excel report. It currently looks for a drive path and then a subfolder.
Is there a way to change the code below to just be the same folder the Access DB is in? So if I move both to a different subfolder they will both work?


Current:

RunCode Function Name OpenExcelFile ("D:\Research\Report.xlsm")

What I am looking to do but it doesn't work:

RunCode Function Name OpenExcelFile ("\Report.xlsm")

 

[Joe4]

Capture the path of the database dynamically and store it in a variable, i.e.

Dim myPath as String
myPath = CurrentProject.Path

Then you can update your code to:

RunCode Function Name OpenExcelFile (myPath & "\Report.xlsm")