Open/close files and copy and paste problem

Newbie here. Below is my code. Attempting to parse through all the tabs in the active worksheet and the ones starting with "x's" I want to pull the data from columns D and E and put into a new .csv file. I have been sucessful but only if the csv files already exists. If I create the file then I am unable to paste into it. I've even attempted to create it, and then close it just to reopen it to no avail. Honestly, VBA with excel is the most agravating coding I have ever experienced. Thanks for any help. Todd
The error it throws is "PasteSpecial Method of Range class failed"

Please Login or Register  to view this content.

Hi Todd;

At first glance I don't see a problem. What is the error message that you get when it crashes?

SOLVED: Moved the "copy" portion after the file create as the create new file wipes out the data in the paste buffer.

The error it throws is "PasteSpecial Method of Range class failed" . If the file already exsists and I just open it then the paste functions as expected.

I did modify this .add.saveas to include the .csv fileformat as I found that it was just saving it as the default type but with a false extension.

OK, someone here suggested that creating the new file would wipe out all of my "copy" data. That was the problem is there was not data to paste.


Can someone suggest code that will eliminate the copy/paste step and just allow me to directly assign the data from one workbook to another? I've tried it but always with errors that I'm at a loss to understand.

Thanks for the hand holding..