Creating a .com file

[Don Wells]

Can someone provide a pointer or two on converting vba code into a '.com' file?

T.I.A.

[HansV]

VBA in an Office application (Word, Excel etc.) can't be converted to an executible directly (.com is rather obsolete, by the way, .exe is far more common these days).
You'd have to create a program in VB.Net, which would require rewriting parts of the code.

If you could provide some details of what you want to accomplish, we might be able to give a more specific answer.

[Don Wells]

VBA in an Office application (Word, Excel etc.) can't be converted to an executible directly (.com is rather obsolete, by the way, .exe is far more common these days).
You'd have to create a program in VB.Net, which would require rewriting parts of the code.

If you could provide some details of what you want to accomplish, we might be able to give a more specific answer.

Thank you for the guidance Hans.
My question was raised as a possible/doubtful solution to the problem which Chris is attempting to overcome here.