Problem with connection string to network excel woorkbook

[jaryszek]

Hi Gurus,

My problem is within connection string from my Query in Excel:

DSN=Excel Files;DBQ=\\nt-wro7-01\dane\IACC\DOKUMENT\Pliki QlikView\raport Łukasz 2.xls;DefaultDir=\\nt-wro7-01\dane\IACC\DOKUMENT\Pliki QlikView\raport Łukasz 2.xls;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;

In my file:

\\nt-wro7-01\dane\IACC\DOKUMENT\Pliki QlikView\raport 09.08.2016.xls there will be report name : "Raport" & today date pulling out every day.

So my connection string should be working similar like this to read this:

\\nt-wro7-01\dane\IACC\DOKUMENT\Pliki QlikView\raport*.xls but this is not working.
How can I connect to this network location but to different names of workbook depends on present date?

Please help Guys,
Best Regards,
Jacek Antek