vba to change query source path

Hello,
I've created 2 queries from data tab>New Query to import csv file
I need vba to change source path from "C:\Folder1\" to "C:\Folder2\" for query 1 and do the same for query 2
I did lot of google search but all solutions focus on ODBC queries
Could anyone help me please?

I will assume you are importing data (Data -> From Text). The following will let you change the path and the file name call it from another subroutine with the syntax: Refresh_Data DirectoryName, FileName. In this case, the connection name is called qry_data. Change that to meet your needs.

Please Login or Register  to view this content.