Export range to CSV not copying data

The code seems to hang on the paste part. When it is running, there is a message in the bottom left corner (hit enter to paste)
I added in the line

Please Login or Register  to view this content.

and that has not helped either...

I also ran a check on the CutCopyMode with the following:

Please Login or Register  to view this content.

and it declared 1 (for copy) each time! Surely I must be missing a trick somewhere...!

I havent tried your full code but add this

Please Login or Register  to view this content.

after this

Please Login or Register  to view this content.

it will remove the message at the bottom.
The above code worked fine to copy the data, open a new workbook and paste the data

Hi,

better to trying to undestand something to your code, attach a source xlsx workbook (no macro)
and a desired result text file according exactly from this source file …

Edit : Sean was fastest … but I 'll create new workbook first and then copy at once with only one instruction !
Or I directly write text file without the need of a new workbook …

Hi Sean & Marc,

I added in the

Please Login or Register  to view this content.

and it doesn't do anything extra, but thanks for the suggestion.
I have created the file as an .xlsx file and what needs to happen is simply the data in the worksheet "DEFECTS" is extracted and stored as a separate file in CSV format with the filename specified in the worksheet PROJECTS D3.

The file is created fine and I cannot see anything wrong with the code as it is, but the data just vanishes as soon as it pastes.DEFECT-TRIAL.xlsx

I will try a re-write to create the workbook then copy across the data and let you know how I get on, but thanks for your input so far!