That helped me, ty. And you answered to my question, as I wanted to open a
file.
But may the code add the sheets to the ones I have right now? Or do I need
to make the macro open the file, copy selected sheet, paste in first work
sheet??

Marie

"Kris" a écrit dans le message de
...
Marie,

Dim Myfilename as String

Myfilename = Application.GetOpenFilename
Workbooks.Open FileName:=MyFilename

Regards,
Kris

-----Original Message-----
Hi, I wondered if there would be a command so that it
asks the user to chose
what file to open.

I've made a program that updates the info in the second
sheet when you press
the button in the first sheet. But I'd need to keep the
result of the
previous month in the second sheet before updating. So
right now, the user
has to copy the information. Is there a way that the
programs open a "open"
box where he selects the excel file and that it copies
it in the 2nd sheet?
(And if you have even better ideas, you may submit it ;-
) )

Thank you.

Marie


.