old excel macro language

[command_z]

Hi all- I just found this website. I wish I would have found it years ago! I am wondering if I am the the only dinosaur out there still using the old macro commands??? I just cant bring myself to use/learn visual basic

 

[Mabocat]

I too like the old language.

 

[Joe4]

I too like the old language.

And old threads too, apparently!
(the thread you replied to is from 2003 -- how in the world did you even stumble across it?)

 

[Mabocat]

I used the search function and I now have from the Net, a PDF with all the Excel 4 macro language.

 

[Mabocat]

While one can write the old macro language, you cannot record the actions in later versions of Excel & you cannot save the file as XLM as that is no longer recognized. It seems one can open an XLM file but not save it as XLM.... ah well, will have to learn VBA...

 

[mikerickson]

VBA isnt hard. If you used BASIC back in the day VBA will be very easy.
What is tough is the Excel Object Model.

 

[rlv01]

I too like the old language.

To each his own. Back in the day I had to maintain a number of worksheets using Excel 4 macros. I hated it. When VBA arrived it was like the sun rising on a summer day.

 

[Mabocat]

Not sure if this is the correct place to ask this
but is there any one who knows of a list that has the old Excel 4 macro names compared to VBA ?
For example
Use WAIT with NOW to pause a macro for a length of time or until the time specified by the serial number. For example, the following macro formula waits 3 seconds from the time the functions are evaluated: WAIT(NOW()+"00:00:03")

the above macro is perfect for printing out a double side page, the WAIT gives time to be able to turn the paper to the other side in the printer.

So I am looking for the VBA equivalent.

 

[Mabocat]

To each his own. Back in the day I had to maintain a number of worksheets using Excel 4 macros. I hated it. When VBA arrived it was like the sun rising on a summer day.

I found them good to use as one could write beside the macro function, what it was doing

[TABLE="width: 629"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Reset.Meal[/TD]
[TD]Reset current meal components[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ECHO(FALSE)[/TD]
[TD]Disable echo on screen[/TD]
[/TR]
[TR]
[TD]=REFTEXT(ABSREF("R[1]C[4]",!Database))[/TD]
[TD]Get start of quantity column[/TD]
[/TR]
[TR]
[TD]=REFTEXT(!Database)[/TD]
[TD]Get entire database range[/TD]
[/TR]
[TR]
[TD]=FIND(":",A18)[/TD]
[TD]Extract end of range cell[/TD]
[/TR]
[TR]
[TD]=MID(A18,A19,999)[/TD]
[TD]Get cell at bottom right of database[/TD]
[/TR]
[TR]
[TD]=A17&LEFT(A20,FIND("C",A20))&5[/TD]
[TD]Form reference to quantity column[/TD]
[/TR]
[TR]
[TD]=SELECT(TEXTREF(A21))[/TD]
[TD]Select it[/TD]
[/TR]
[TR]
[TD]=CLEAR(3)[/TD]
[TD]Clear all quantities enter by user[/TD]
[/TR]
[TR]
[TD]=SELECT("RC:RC")[/TD]
[TD]Clear selection[/TD]
[/TR]
[TR]
[TD]=RETURN()[/TD]
[TD]Return to caller[/TD]
[/TR]
</tbody>[/TABLE]

but as you said "To each his own"

 

[Mabocat]

VBA isnt hard. If you used BASIC back in the day VBA will be very easy.
What is tough is the Excel Object Model.

I used the old LOTUS 1-2-3 first followed by Quattro Pro, then the work place (Telecom Australia) changed over to Microsoft so I had to learn Excel and automate a lot of spreadsheets for other Users and got quite good at Excel 4 macros and VBA just started to show its face when I retired - never learnt BASIC.

Ron