MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Grabbing the value of a cell in a different workbook

  Asked By: Cody    Date: Nov 07    Category: MS Office    Views: 2286

Supose my archive "01.xls" is opened.
I want to run a VBA macro and grab the value of the cell A1 from the
archive '02.xls' and put it in the cell B1 of the archive '01.xls'.

Can anyone show me a few codes ?



2 Answers Found

Answer #1    Answered By: Isabella Campbell     Answered On: Nov 07

From a different peanut gallery. Can you grab  the value of the cell  if its
open and active on a different computer?

To answer the question above, open both sheets, select the active cell, to
want the value to go to, type "=" then browse to the other workbook  and
select the cell with the value you want to pull over. When you close 02.xls
the shortcut will still linking to the value in 02

Answer #2    Answered By: Logan Bouchard     Answered On: Nov 07

Yes. When you open the file, it'll tell you that it's already in use. Just
select the read-only option and it'll open enough to grab  information out of

Didn't find what you were looking for? Find more on Grabbing the value of a cell in a different workbook Or get search suggestion and latest updates.