G
GTVT06
I'm getting a Run-Time Error '424' Object required error on Ln 7, Col
1 when running the following macro. I'm attempting to open a Query and
export it and name the file name qryEvansDailyRTA & whatever the Date
is in the Date column of the query.xls I cant figure out what's
causing the error. Any assistance is greatly appreciated.
Sub Export_RTA()
Dim FileName As String
DoCmd.OpenQuery "qryEvansDailyRTA"
FileName = "T:\Departments\Operations\WFM\RTA eWFM ASC Daily Reports
\Evans\DailyRTABreaks\MAR\""qryEvansDailyRTA" & Queries!
[qryEvansDailyRTA]![Date] & ".xls"
DoCmd.OutputTo acOutputQuery, "qryEvansDailyRTA", acFormatXLS,
FileName, False, False, False
DoCmd.Close acOutputQuery, "qryEvansDailyRTA"
End Sub
1 when running the following macro. I'm attempting to open a Query and
export it and name the file name qryEvansDailyRTA & whatever the Date
is in the Date column of the query.xls I cant figure out what's
causing the error. Any assistance is greatly appreciated.
Sub Export_RTA()
Dim FileName As String
DoCmd.OpenQuery "qryEvansDailyRTA"
FileName = "T:\Departments\Operations\WFM\RTA eWFM ASC Daily Reports
\Evans\DailyRTABreaks\MAR\""qryEvansDailyRTA" & Queries!
[qryEvansDailyRTA]![Date] & ".xls"
DoCmd.OutputTo acOutputQuery, "qryEvansDailyRTA", acFormatXLS,
FileName, False, False, False
DoCmd.Close acOutputQuery, "qryEvansDailyRTA"
End Sub