Excel 4 macros to VBA?

[Guest]

Is anyone aware of a utility that will translate Excel 4 macros to VBA?
I know this is a lazy man’s question but some of my old coding is over 5,000
lines and I am just not that keen on doing all the work necessary to manually
re-code to VBA.

 

[Gary Brown]

You don't have to convert Excel 4 macros. They still run in the
latest version of Excel. Don't know about future versions but they will
probably continue to be supported.
HTH,
Gary Brown.

 

[Gary Brown]

You don't have to convert Excel 4 macros. They still run in the
latest version of Excel. Don't know about future versions but they will
probably continue to be supported.
HTH,
Gary Brown.

 

[Guest]

Yes they do but it would be better to have a more current form.

 

[Dave Peterson]

A couple of suggestions that make sense to me is to not even look at the old
code. Find out what the macro is supposed to do and write it in VBA.

You'll be able to enhance it using all the new techniques (nice userforms???)
that have been added in xl95+.