I am new to programming in Excel with VBA and I have spent 4 hours searching
the archives for a solution to my challenge.

I am developing a simple application for other users who may or may not have
a lot of computer knowledge. I am making it as user-friendly as possible with
user forms and locking areas of the workbook they shouldn't mess with.

The procedure the users will follow:
1. Open 'my workbook' [which contains all of the macros needed for the rest
of the operation]
2. Autostart an 'input box' which will allow them to select a file [could be
in .xls or .csv format- the file is unique to their location] which will
import the 'worksheet' into 'my workbook' as the last worksheet.
3. Use further userform-based macros to chart their 'worksheet' data.
4. The added 'worksheet' must be deleted automatically when 'my workbook'
closes.

Can anyone suggest a macro [step 2] for choosing, opening and inserting the
unique file and another [step 4] that would delete the worksheet upon closing?


Any help would be appreciated.

Thanks,
Mike