In Chip Pearson's macro to compare 2 spreadsheets, he uses a form in
which you enter the names of the 2 spreadsheets you wish to compare.
I'd like to use that same form for a macro I'm writing which compares
the rows in 2 spreadsheets and does some manipulations on them.

I looked at the code for Chip's macro, tried to copy what I thought
were the appropriate parts into my spreadsheet, and run it. It didn't
work. I'm not sure if I got the right code, his macro is so advanced to
me that I couldn't make sense of most of it.

I tried to modify Chip's form by removing the controls I didn't need,
then exporting it to another directory, change the name, the import it
back in, but that didn't work either.

What I'd like to do is have a form that allows the user to select 2
files from any open files, just like Chip's does, but then have my code
run on those files. Can anyone help me here, point me in more
productive directions?