Popup box to select open workbook and copy/paste from it

  • Hi,

    I’m sorry, I try myself at VBA coding but still not very good at it ?

    So I have some macros that work, but before running them I need to import data into the workbook my macros are in.

    So I want to have one workbook open with the macros (let’s call it code workbook), and then the source is a CSV workbook (1 column, x lines) which should also be open.

    Basically I want to be able to click on a button in the first sheet of the Code Workbook, and then have a popup box listing all open workbooks for me to choose from.

    Then when I chose the Source Workbook from the popup box, I would like the data of the first sheet of the Source Workbook (which always has a different name, because it’s extracted from another software) to be copied and pasted in another sheet of my Code Workbook.

    Then I’ll figure out a way to run the macros I do have.

    Is this something difficult ? I don’t know where to start …

  • Hi and Welcome to the Forum :)

    You basically need to import a csv file into your workbook ... which is a very common situation ...;)

    Do you already have a macro ?

    Are you using the following instruction :


    Hope this will help


    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

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