How to call a file (.txt file) and paste it on the same WORKBOOK.

[louierosales]

I hope you can help me. I have a problem that after I call a file (.txt), it automatically open a new workbook. I dont like this to happen instead I want it to be on the other spreadsheet only not to be paste on the other file.

Thank you so much!

 

[Trevor G]

Welcome to the Forum,

What code are you using to do this?

 

[louierosales]

Trevor,

Im using Excel 2007...Im doing Macro program using VB...

 

[Trevor G]

Can you show your code so I can take a look.