MS Excel Interaction - The Final Fight

[El_Ga]

Well, I come to your aid with this... I´m trying to make an AMS Project interact with an MS Excel .XLS file... And I just can´t make it happen...

I read about LUACom, XLS, etc, etc.... But now I´m definitively LOST :rolleyes


What I want to do:
Read the info from an SPECIFIC cell (lets say, "B4") and put it into a variable.
Work with that in AMS.

PLUS, if it should be possible: (am I asking too much, maybe?)
Then WRITE that to the same (or other) SPECIFIC cell in the .XLS document

Does anyone know how to do this, or have an example??

My LUACom, XLS, SQLite are almost zero... :huh

If anyone can help with this, I´ll be infinitely grateful

Thanks in advance....

Gastón

[usernameCasper]

learn some VB(A).
You can use macro in VB for automate things out, then import them in AMS.
But beware you must set the security for Macros in Excel to "LOW", keep this in mind if you want to distribute your app to the rest.
VBA is very easy to learn, i bet you can make this work in 1 week.

Good Luck,
-Casper