VBA open text file and save into existing workbook

  • Hi all,

    I'm currently using VBA to do the following tasks:

    - open a text file

    - select only the relevant data

    - paste the data into a defined sheet in my workbook

    I managed to get the first two points done, however the data are displayed in a new workbook so I would need to copy and paste manually into my workbook. Is there anyway to paste the data automatically into my existing workbook rather than opening a new one?

    I'm trying to make that process automatic but I'm afraid my vba skills are way too limited. Would anyone be able to help me?

    Here is my code:

    Thank you!


  • Does this help?

  • Does this help?

    Yes, that's it!

    Thank you for your help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!