Excel CurrentProject.Path, runime error 424

Question

I have never ever done anything in VBA for excel before. I have my whole dashboard working when the .accdb is in C drive but now i want it in the same folder as excel workbook.

Im getting "Run-time error '424: Object required" for the bottom line below

Dim DatabasePath As String
DatabasePath = CurrentProject.Path & "\SpreadSheetData.accdb"

Why is this? Thanks for your help

Answer 1

There is no CurrentProject in Excel. If you want to refer to the workbook in which the executing code resides, use ThisWorkbook instead.