Excel macro non VBA

Question

I have an Excel file that opens up with a Macro tab with a code that doesn't seem to be VBA. When enabling the macros warning in excel it formats the file as per the macro.

What type of code is this? Does anyone know where I can get more information how how to code this type of macros?

See below what this the code for this macro looks like:

That is deffinitelly not a macro. They seem to be reference formulas for a macro, have you found any code in the Visual Basic editor? try opening it with alt+f11 — Martin Router King
– Martin Router King, Commented Sep 13, 2017 at 8:19

ainwood · Accepted Answer · 2017-09-13 08:45:25Z

4

It's an old Excel 4 macro, from before there was a VBA editor. It is still supported in the latest excel versions - right-click on the "sheet tabs" in an excel workbook, hit "insert", and one of the options in the dialog is to insert an MS Excel 4.0 Macro. Select that, and it will insert a sheet that looks like a worksheet, but allows macros like this.

Some useful links on migrating them:

Working with Excel 4.0 Macros

And:

Migrating Excel 4 Macros to VBA

If you want to try to work with the Excel 4 macro, you can get a help file (from Microsoft) Here.

answered Sep 13, 2017 at 8:45

ainwood

1,0487 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bathsheba · Accepted Answer · 2017-09-13 10:00:28Z

2

Wow. This takes me back. It's the pre-1997 way of coding macros, before Microsoft Excel 1997¹.

Lotus 1-2-3 pioneered it. Are you sure the workbook didn't begin life as a 1-2-3 spreadsheet?

Naturally you ought to attempt to port such stuff to newer technologies despite Excel still supporting in-worksheet macros.

There are a few conversion tools dotted around the internet. See http://www.xlhelp.com/Excel/Lotus.htm for example.

¹Which, in my humble opinion, was at the time the best application ever written.

edited Sep 13, 2017 at 10:00

answered Sep 13, 2017 at 8:20

Bathsheba

235k35 gold badges376 silver badges504 bronze badges

3 Comments

Zac Over a year ago

That threw me.. it just looked like a normal sheet calling UDF's.. but you are absolutely right.. I had forgot about the old lotus format :). Good shout!

Selrac Over a year ago

The files are produced by Oracle BI Discoverer 11g. Hopefully the new versions of Oracle will be a bit more updated with the macros

Bathsheba Over a year ago

@Selrac: Indeed. And note the other answer (that I've upvoted) is more truthful than this one, even after my cheeky edit.

Collectives™ on Stack Overflow

Excel macro non VBA

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related