LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? excelnovice Excel Worksheet Functions 2 September 25th 05 12:38 AM
Making excel macros run Word macros Matthew McManus Excel Programming 1 February 18th 04 02:57 AM
Can macros alter locked cells in excel? nigelbellamy[_2_] Excel Programming 1 January 16th 04 10:22 AM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"