Import data from specific named PDF located in same directory

[BazRaketak]

Hello guys,

I am using VBA with Power Querry to import table from PDF to Excel and then managing data there. Now I have staticaly set up path to input file: source.pdf

Is it possible to use some shortcut in path or any simple coding, how to set up taking that source.pdf as import automatically from same directory, where my excel file is located? I want to have it not static in case some detail in path will change in future.

Thanks!

[ranman256]

can you not store the file path in a cell, and import from that?
Then its easy if the file changes.