Re: *****Excel_Vba:"ID:"225*** How to update all closed worbook while Updating master workbook

[Avantika DasGupta]

Hi
You can use attached macro.Please change the path accordingly.
In my case it is.
F:\Sample\Book1.xls
F:\Sample\Book2.xls
F:\Sample\Book3.xls
F:\Sample\MASTER.xls










Thanks Regards
Avantika DasGupta

[Shivam Shukla]

Hello Avantika,
Nice work.This macro is great.I  was using linking before this.
Book1 cell a1
='C:\New folder\[MASTER.xls]Sheet1'!$A$1

similarly in all workbook and each cell we can put the formula,And we will
got the updated value from master to all workbook.

--
You received this message because you are subscribed to the Google Groups "MS Excel Macro Vba" group.
To post to this group, send email to exce...@googlegroups.com.
To unsubscribe from this group, send email to excel_vba+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/excel_vba?hl=en.

[Avantika DasGupta]

Hey Shivam,
You are right, We can put the formula.But it will consume much time
to put formula in each cell.


I think it is not easy to put formula in each cell {A1:IV65536 in 2003}
& in each workbook.
:)

Thanks for kind consideration.













Thanks Regards
Avantika DasGupta

---

Date: Mon, 19 Sep 2011 14:54:13 +0530
Subject: *****Excel_Vba*** Re: *****Excel_Vba:"ID:"226*** How to update all closed worbook while Updating master workbook
From: shivam.s...@gmail.com
To: exce...@googlegroups.com