Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Cell AZ99 is in sheet 7 and book1.xls , can I reach the value in it ( without ) opening book1.xlsx and add it to another workbook like book2.xlsx?

Microsoft Excel MS Office Automation Microsoft Windows MS Office tools
user-image
Question added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/02/25
Upvote (1) Views (2) Followers (2) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Riya Antony LNU
by Riya Antony LNU , Intern , Mithril Telecommunication Ltd

The formula to be used in the cell in Book2 is

='[Book1.xls]sheet7'!$AZ$99

Write Your Answer
More Questions Like This