S
Stefan Schier
Hi folks,
wonder if anybody could give me a hint or a usefull link where I can find
something about the syntax and usage of Excel 97 macro programming directly
written in cells.
I need to convert a couple of those sheets to VBA but I don't really have a
clue about this old kind of programming in Excel.
Here is an example to illustrate the way it is now:
KOSY_AUFTRAG
=RESULT(1)
=ARGUMENT("Kosy_Pfad",2)
= ALERT("Kosy_Pfad: "&Kosy_Pfad,2)
=ARGUMENT("Kosy_Anwender",2)
=ARGUMENT("A_Richtung",2)
=ARGUMENT("A_Art",2)
=ARGUMENT("A_Ergebnisdateien",2)
=ARGUMENT("A_Mappe",4)
EXCEL4=VALUE(LEFT(INFO("Version"),1))<5
=IF(OR(ISERR(A_Mappe),ISNA(A_Mappe)))
A_Mappe=EXCEL4
=END.IF()
=CALCULATION(3)
=NOW()
=ECHO(Bild_Aktualisieren)
KEV_KL=0
KEV_Start_Zelle=ACTIVE.CELL()
=CANCEL.KEY(Bild_Aktualisieren)
=FORMULA.GOTO(KEV_endewert)
=CLEAR(3)
Although I'm programming in VB and VBA for a couple of years now, I've never
seen this way of using makros.
Any help would be appreciated.
Thanks in advance.
Stefan
wonder if anybody could give me a hint or a usefull link where I can find
something about the syntax and usage of Excel 97 macro programming directly
written in cells.
I need to convert a couple of those sheets to VBA but I don't really have a
clue about this old kind of programming in Excel.
Here is an example to illustrate the way it is now:
KOSY_AUFTRAG
=RESULT(1)
=ARGUMENT("Kosy_Pfad",2)
= ALERT("Kosy_Pfad: "&Kosy_Pfad,2)
=ARGUMENT("Kosy_Anwender",2)
=ARGUMENT("A_Richtung",2)
=ARGUMENT("A_Art",2)
=ARGUMENT("A_Ergebnisdateien",2)
=ARGUMENT("A_Mappe",4)
EXCEL4=VALUE(LEFT(INFO("Version"),1))<5
=IF(OR(ISERR(A_Mappe),ISNA(A_Mappe)))
A_Mappe=EXCEL4
=END.IF()
=CALCULATION(3)
=NOW()
=ECHO(Bild_Aktualisieren)
KEV_KL=0
KEV_Start_Zelle=ACTIVE.CELL()
=CANCEL.KEY(Bild_Aktualisieren)
=FORMULA.GOTO(KEV_endewert)
=CLEAR(3)
Although I'm programming in VB and VBA for a couple of years now, I've never
seen this way of using makros.
Any help would be appreciated.
Thanks in advance.
Stefan