I converted a small .exe in VBA through vba2exe.rb in BT4 R1. Embedded it in MSword and it worked like a charm.
But When I try to embed it in MS Excel it gives the error "User-defined type not defined".
i ran through script and found that this piece of code is actually creating problem:-
Sub Auto_Open()
End Sub
Sub Kquip12()

Dim Kquip4 As Paragraph

Code stops here. A logical reason is that it is defining a paragraph that is supported in word but not in Excel.

What can be the way around.

The second problem which I am facing is that if I try to embed any file greater than 1 Mb. It simply doesn't run.