Workbook attached with 2 queries as below.
Fiscal year variable (user input)
Posting period variable (user input)
Fiscal year/Period Replacement path Variable from Query -1
Replacement path variable should fill the values of Fiscal year and Posting period from Query-1 to Query -2 Fiscal year/period , so user dont have to key in input .
Workbook - Query - <b>Properties</b> (Refresh query when opening Workbook) has been set for all 3 queries.
currently while opening workbook it directly goes to query-2 and fails instead of going to query 1.
How to achieve it??
thanks for help