Dialog box to select a file to extract from (without open it)

[igortorrealba]

Dear all,

I am trying to write my first code, it will extract (copy) content from different sheets and cells from a file (source) and paste it into the next empty row of another existing file (the database)

The source has always the same exact structure, only different data, the previous idea is the simple part (no so simple for a complete novice), but to go beyond (once I have completed the basics), I would like to write a piece that will allow the user to:

Get a dialog box to select the file to extract from (without open it), if success, the a dialog box stating the id of the new record added to the database (the id is part of the simple code as an incremental number, no need to get deep on that)

So far I have found answers to open the file, but once I crack the first part of my code, I will not even want to see the file from which I extract the data (usually a heavy one).

Thanks a lot, I hope this is simple yet not too simple to make me feel dumb