WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

OLE COM ADO CDO ADSI LDAP
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

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:
  1. macro code readily uses with...endwith which WB cannot emulate
  2. macro code understands references to Me or ThisWorkbook which WB cannot emulate
  3. macro code often uses internal array handling, i.e. redim() that WB cannot emulate.
  4. [related to #2] - WB has to use explicit references in parameter coding
  5. WB often requires () for methods which VB or macro code does not.
  6. 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