Export excel data to another excel workbook

[PRodgers4284]

I have a macro that writes data from one worksheet to another inside the same workbook. I want to write the data to another workbook if this is possible using my code below, i was wondering could i change the first line of the code "Set wsData = Sheet2" to the pathname of the workbook and worksheet i want to write the data to, i dont think this will work though, anyone have any ideas?

Please Login or Register  to view this content.

[The Headacher]

you can use the workbooks.open function to open a workbook (didn't check the code, it's just to give you an idea)

Please Login or Register  to view this content.

don't forget to close the workbook after you're done with it!

[shg]

Please Login or Register  to view this content.

[The Headacher]

Ah, yes of course. Sorry about that ....