Hey everyone,

I have this challenge that I'm hoping someone can help me crack. I'm able to run access queries from excel using the following code. How could I adapt this to include a parameter? Any thoughts? The version of Access I'm using is Access 2010.


Set AC = CreateObject("Access.Application")
With AC
.OpenCurrentDatabase ("I:\clt\Analysts\AnthonyP\DatabaseBackup\DataWareHousBackend.accdb")
.CurrentDb.Execute "qryContractorHoursAppend"
.Quit
End With