Hi - how would I go about refreshing a query in another workbook?
My example
Workbook1
Sheet 1 - contains a list of timesheet data. This data looks up to the data stored in Sheet 2
Sheet 2 - reads data from many different timesheet files. Contains a Query that when run, will update the data. Call this Query1.
Workbook2
Sheet 1 contains all the user data stored in Workbook1[Sheet1]. The user updates their info which needs to be saved by running Query1.
I need a command button in Workbook2 that will refresh Workbook1[Query1].
OnClick.Refresh."Workbook1"."Query1"
Thansk!
My example
Workbook1
Sheet 1 - contains a list of timesheet data. This data looks up to the data stored in Sheet 2
Sheet 2 - reads data from many different timesheet files. Contains a Query that when run, will update the data. Call this Query1.
Workbook2
Sheet 1 contains all the user data stored in Workbook1[Sheet1]. The user updates their info which needs to be saved by running Query1.
I need a command button in Workbook2 that will refresh Workbook1[Query1].
OnClick.Refresh."Workbook1"."Query1"
Thansk!