Problems Writting a VB to WinBatch OLE Code Converter
Microsoft implements macro code for Microsoft VB - so the best WB can do is approximate the constructs:
- macro code readily uses with...endwith which WB cannot emulate
- macro code understands references to Me or ThisWorkbook which WB cannot emulate
- macro code often uses internal array handling, i.e. redim() that WB cannot emulate.
- [related to #2] - WB has to use explicit references in parameter coding
- WB often requires () for methods which VB or macro code does not.
- No way [yet] to emulate event-coding in macros or macro events themselves.
Chances are you could write a script to perform a line by line conversion of a Sub to a UDF - I just think it would be
more difficult to debug.
Article ID: W16559
File Created: 2005:02:18:12:21:28
Last Updated: 2005:02:18:12:21:28