Error 438: Object doesn't support this property or method

[StuLux]

When I run my code (which opens Excel from Access) it does everything it is supposed to but I then get the above error but I do not get the error if I open the VBA window and then run the code. (The code is password protected, not sure if this is relevenat though).

Can anybody explain why this might be and what this error might be referring to?

 

[Norie]

Stuart

I suggest you take a look at creating the SQL for a query that does the filtering and then exporting that to Excel using TransferSpreadsheet.