how to compile or convert my excel and word macros

[yesilkalem]

I have some word and excel macros in vba. and I want to run it without opening word also I want to compile it and an independent program in order to commit my txt files. how can I do?

thanks

 

[ufobaby]

hi,

from Project>References select "Microsoft Word 8.0 Library"
then

Dim objWrd as Word.Application

Set objWrd = CreateObject("Word.Application&quot
objWrd.Documents.Open("c:\test.doc&quot
' By default the application is not visible
'to make it visible use ->
objWrd.Application.Visible = True

.... then start using the VBA code but with the reference of your Object i.e "objWrd"

Hope this helps els write back....


Niraj