Issue with finding data source using CurDir

Hello,

I'm having an issue with my code below. I'm using the CurDir function to find the current directory (which also holds the data csv file). The directory is found as well as the file, but when trying to query the data source I get the error too few parameters expected 2. When I place the data source file into my local C:\ drive and run the application file from the existing location which is a mapped network drive, everything runs as it should. Only when I place the data source into the network drive, I get that error. Any ideas what may be causing this?

Thanks in advance.

Please Login or Register  to view this content.

To find the CurDir:

Please Login or Register  to view this content.

If you want to reset it:

Please Login or Register  to view this content.

Or, you can use the activeworkbook or that workbook's path:

Please Login or Register  to view this content.