Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Updating workbook version

1

I created 1  workbook named sara ver 7.0.xlxm that contains macros, around 50 sheets and contains so many formulae.

And i sent this to my friends all over State, all my friends downloaded and gave their school students  data's.

After that i modified some changes in that workbook and named sara ver 7.1.xlxm.

If i send this new workbook to our friends, how can they updated the old workbook without loosing entered student data's.

How to do this?

Please give solution.

Answer
Discuss

Discussion

1 vote from my side for such a precious question!
Chhabi Acharya (rep: 111) Aug 16, '18 at 6:49 pm
Add to Discussion

Answers

0

You might provide a program to the recipients which they can run to do one of the following.

  1. Apply the changes you made to your workbook to theirs, or
  2. Import the data from their workbook into yours to create a combined and updated copy.

I would guess that the second method should be easier because (a) it doesn't touch the recipients' data and (b) you can know that anything found in the other workbook that isn't contained in yours must belong to the recipient. If such changes affect formulas, however, the differences may be irreconcilable. Basically, if there are multiple recipients and they have been working with their copies of the workbook there is no telling what may have been done.

The project may be too big and too difficult to succeed but it must start by looking minutely at the changes you have made, one by one, and considering the implications of each change.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login