Excel VBA: Problem with porting selected data from one excel workbook to another

Originally Posted by Norie

Then there's no need to create another instance of Excel, and doing so can cause problems when copying/pasting.

Erm, i need to have a "3-tier" system because
the source file is a file with raw data generated from a Microsoft Access function. You might suggest that we could just change the queries in the Microsoft Access to suit my end product, however it'll be messy if everything is ported straight from the Microsoft Access as you can see in the previous posts, there're addition of columns. I hope that explains my need for another instance of excel. haha