I am working on a spreadsheet from which a user can choose to import
data from a saved workbook. Once the user has chosen the import
workbook through a file chooser dialog, it is opened and checked for
validity. The user then chooses the subset of the data they want
through a simple userform.

How can I get a reference to the workbook that has been chosen and
opened so that I can act upon it from the userform or the procedure
that calls the userform? There is no code in the import workbook as it
is just raw data.

Is this a place for a global variable?

Thanks.

Mark