word vba to write or copy module to excel

[MikeB77]

Is it possible to use word vba to write or copy code to a module or workbook
in excel? Like extending 'Application.OrganizerCopy', or
'application.vbe...' or something.
has anyone tried this?

thanks

Mike

 

[Helmut Weber]

Hi Mike,

Is it possible to use word vba to write or copy code
to a module or workbook in excel?

should be, if you got a reference to the extensibility library,
and the security settings are right.

If it has to be, I'd try you export the code
and import it in Excel.

has anyone tried this?

Not me. I never was in a situation,
where programmatically exporting word code
and importing it into Excel was required
or even would have made sense.

I played a bit with vbe and got as far as that:

With Application.VBE.ActiveVBProject.VBComponents(3)
.Export "c:\test\Word1\test.txt"
End With

If it helps, its alright, but as I see no use in it,
I leave further steps to you.

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

 

[MikeB77]

Thanks Helmut
yes, its a strange idea, not one of my best. While the code in question runs
under both word and excel, the event procedures are a probelm and overall may
be more pain than gain.

Mike