Query export to Excel through button

[moi]

@Gasman Apparently the OutputTo has different arguments than TransferSpreadsheet does and so cannot create the other format spreadsheet.

Moi has language issues and so has trouble following directions and that makes him very difficult to help. Perhaps he will understand my last suggestion and get the dots out of the file name and try that. Or, try using the TransferSpreadsheet and perhaps get a different error message which will help to identify the problem.

Dear all,

Thank you all for sharing your time helping me..

I sorted thank you.

 

[cheekybuddha]

I sorted thank you

Please share your final solution. It will help other users here who may have the same problem.

 

[Gasman]

We are over 40 posts in this thread , so as cheekybuddha asks, please post the solution. You are here to give as well as take. That is the premise for the forums.