Discussion Article

Subject:
Equation Editor in MS-Word couldn't be linked due to changing variables from MS-Excel
Name:
Serhat OZLER
Email (spam proof):

Email the originator of this post
Date:
Tuesday, December 21, 2004
Hits:
52
Discussion (Terms and Conditions):

Greetings to everybody

I'm a civil engineering student and i'm using VBA Macros for my Homeworks and School Projects.

I'm using Excel to calculate the data and then i'm making reports with Word.

So i'm making some data connections between Word and Excel.

With this process,i can calculate(in Excel) and report(in Word) my homeworks synergically and synchronously.I mean i can change the results of the calculation.That doesn't mean that i have to change it in Word file too(because it changes automatically).Or the same with the other way around.

It is useful in lots of case but one not:I can't make connections(link) between Word and Excel if i work with equation editor.

Let me give a little example please:

I'm calculating in Excel and the result is

m=20 kg

this results goes to Word file too.

and then i found the acceleration

a=0.5 m/sec^2

Now i have to find Force.And i type

F=m.a=20*0.5=10 kg.m/sec^2 => I WROTE THIS PART WITH EQUATION EDITOR <=

Then i'm realising that i found m(Mass) wrong.I'm recalculating and

m=30 kg

This time in Word file;

m=30 kg => it changes succesfully! <=
F=m.a=20*0.5=10 kg.m/sec^2 => but this part is not connected.So still wrong <=

--------------------------------------------

I think you took the point.I have make the Equation Editor to be linked or i have to find another way to make my homework like this.

I'm widely open for every ideas.Because i stuck:(

Kind Regars
Serhat OZLER

NOTE:I tried Eq field from Word_Menus/Add/Field. It works in the first look but doesn't have so many options.And the capabilty changes due to language.Not so trustable like VBA.I mean you can write:

"EQ \b \bc\{ (\r(30,x))"

and you can modify it like this

"EQ \b \bc\{ (\r(" & Variable_Mass & ",x))"

but anyway,you can't make complex equations with this way.

Sponsored by the best FTP application on the internet: