Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Making excel macros run Word macros | Excel Programming | |||
Can macros alter locked cells in excel? | Excel Programming |