Excel 97 macros in cells?
 

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

Excel 97 macros in cells?
 

There are Excel 4 macros written on Macro Sheets. There is no easy
conversion or any utility to do it. You would need to understand the
functionality of the code and recreate that in VBA.

You can download the help files for Excel 4

http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)

http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)

--
Regards,
Tom Ogilvy


"Stefan Schier" wrote in message
...
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

Excel 97 macros in cells?
 

Thanks, Tom.

I think I can develop almost anything once I understand what the output
should be ;-)
Will look at the files.

Stefan

"Tom Ogilvy" schrieb im Newsbeitrag
...
There are Excel 4 macros written on Macro Sheets. There is no easy
conversion or any utility to do it. You would need to understand the
functionality of the code and recreate that in VBA.

You can download the help files for Excel 4

http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)

http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)

--
Regards,
Tom Ogilvy


"Stefan Schier" wrote in message
...
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