Import Button For Excel 2007

I've been trying to create a button that allows the user to open a csv file and import the data from that into the worksheet, without losing the existing spreadsheet format. I can do it with cut and paste, but want to be able to just import by choosing the file in a dialog box.

Here's what I have, so far:

Please Login or Register  to view this content.

Any way to force the subroutine to open a dialog box and import the data, by choosing the file, without disturbing the buttons and routines on the sheet?

Thank you.

Thanks for the fast reply, Marvin.

Unfortunately, that overwrites all of the buttons and code.

Thank you, Marvin. I'll definitely have to try it in the morning.

Sorry, I'm suffering brain block from lack of sleep, at the moment.

Much appreciated.