I am having a very peculiar problem.
I am using the following code to open an Excel File from Access -->
// Code Starts //
DoCmd.OutputTo acOutputQuery, "qryOutputIncommingVsMeasuredToExcel", "*.xlsx", "Q:\Some Path\MeasuredVsIncommingRawData.xlsx"
Dim AppExcel As Object
Set AppExcel = CreateObject("Excel.Application")
AppExcel.Workbooks.Open "Q:\Some Path\MeasuredVsIncomingAnalysis.xlsx"
AppExcel.Visible = True
AppExcel.ActiveWorkbook.Refreshall
\\Code Ends\
The file that opens (Analysis) has some links to the file that is outputted by the query(Raw); and is getting it's data from the query output.
The files opens, but none of the data is updated. If I close the file and open it again from it's location, it prompts me to update the external links and everything is updated correctly.
How do I get the file to show the refreshed data when it opened from Acess?
Thank You!
I am using the following code to open an Excel File from Access -->
// Code Starts //
DoCmd.OutputTo acOutputQuery, "qryOutputIncommingVsMeasuredToExcel", "*.xlsx", "Q:\Some Path\MeasuredVsIncommingRawData.xlsx"
Dim AppExcel As Object
Set AppExcel = CreateObject("Excel.Application")
AppExcel.Workbooks.Open "Q:\Some Path\MeasuredVsIncomingAnalysis.xlsx"
AppExcel.Visible = True
AppExcel.ActiveWorkbook.Refreshall
\\Code Ends\
The file that opens (Analysis) has some links to the file that is outputted by the query(Raw); and is getting it's data from the query output.
The files opens, but none of the data is updated. If I close the file and open it again from it's location, it prompts me to update the external links and everything is updated correctly.
How do I get the file to show the refreshed data when it opened from Acess?
Thank You!