Unless there is more to your question than you are asking, you don't really
need any code. Althought regarding the Range argument, VBA Help says:
"When you export to a spreadsheet, you must leave this argument blank. If
you enter a range, the export will fail."
It is not true. You can use the Range argument for exports.