Hi,

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

Thanks.

lc

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

--
Don Guillett
SalesAid Software

"lc" wrote in message
ups.com...
Hi,

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

Thanks.

lc

Not that I have ever heard of.

--
Regards,
Tom Ogilvy


"lc" wrote in message
ups.com...
Hi,

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

Thanks.

lc

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 he

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=442508

old style dialog sheets

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

--
Jim
"dominicb" wrote in
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 he
|
| http://www.appspro.com/Utilities/DialogConverter.htm
|
| HTH
|
| DominicB
|
|
| --
| dominicb
| ------------------------------------------------------------------------
| dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
| View this thread: http://www.excelforum.com/showthread...hreadid=442508
|