Excel 4 macro conversions

[lc]

Hi,

Is there a program out there where I can convert Excel 4 macros into
VBA format for Excel 2000?

Thanks.

lc

 

[Don Guillett]

Have you tried just running the xl4 macros and recording a vba macro.

 

[Tom Ogilvy]

Not that I have ever heard of.

 

[dominicb]

Good evening lc

Unfortuately not. Excel 4 macros are vastly different to VBA code and
in most cases the macros will still run without too much problem - and
if such a utility did exist it would probably produce ineffeicient code
that would be better of being rewritten, or used unmodified. There is
however a program that will convert the old style dialog sheets into
their more modern UserForm counterparts. If that's any use to you, you
can find it here:

http://www.appspro.com/Utilities/DialogConverter.htm

HTH

DominicB

 

[Jim Rech]

old style dialog sheets

They first appeared with Excel 5. In Excel 4 you had dialog definition
ranges.<g>

--
Jim
message |
| Good evening lc
|
| Unfortuately not. Excel 4 macros are vastly different to VBA code and
| in most cases the macros will still run without too much problem - and
| if such a utility did exist it would probably produce ineffeicient code
| that would be better of being rewritten, or used unmodified. There is
| however a program that will convert the old style dialog sheets into
| their more modern UserForm counterparts. If that's any use to you, you
| can find it here:
|
| http://www.appspro.com/Utilities/DialogConverter.htm
|
| HTH
|
| DominicB
|
|
| --
| dominicb
| ------------------------------------------------------------------------
| dominicb's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=18932
| View this thread: http://www.excelforum.com/showthread.php?threadid=442508
|