Mike,
Forgive me for bothering you, but instead of simply copying the data, I need
to paste just the Values into the destination spreadsheet. I tried to modify
your code using the PasteSpecial Method (Operation:=xlPasteValues), but I
can't seem to get it to work. I would greatly appreciate your help on this.
Thanks, Bob
"crazybass2" wrote:
Bob,
Didn't I answer this for you already?
http://www.microsoft.com/office/comm...xp=&sloc=en-us
Mike
"Bob" wrote:
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