I need to copy data from spreadsheet €œABC€� (not its real name) thats located
on a shared drive, to spreadsheet €œXYZ€� (also not its real name) located on
my local hard drive. The range of cells to be copied from ABC will always be
€˜Detail Data!H6:H990. The destination starting cell will always be
€˜Consolidated Data!A2.

The macro would need to prompt the user for both the originating and
destination locations (using Windows standard File | Open dialog box).
Since ABC is located on a shared drive, there may be times when ABC is in use
by another user and therefore locked, except for read-only capabilities.
Consequently, the macro would also need to check for that condition, and if
it exists, automatically select the read-only option.

Being new to VBA, I would greatly appreciate any help in writing the
aforementioned macro, especially since two spreadsheets are involved.

Thanks.