I need to copy a column of 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
spreadsheet €œABC€� will always be €˜Detail Data!H6:H990. The destination
starting cell in spreadsheet €œXYZ€� will always be €˜Consolidated Data!A2.

The macro needs to be run from within spreadsheet €œXYZ€�. Since spreadsheet
€œABC€� is located on a shared drive, the macro would need to prompt the user
for its location (using Windows standard File | Open dialog box). In
addition, there may be times when spreadsheet €œABC€� is in use by another user
and therefore locked, except for read-only capabilities. Consequently, it
would be nice if the macro could 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, Bob