View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] johnmanivong@earthlink.net is offline
external usenet poster
 
Posts: 6
Default Urgent help needed please

On Mar 22, 10:31*pm, sriram wrote:
*Set objword = New Word.Application
* *Set objDoc = objword.Documents.Open(DocumentPath +
"\ECB_Document.doc")
* objword.Visible = True
* objword.Activate
* objword.Run ("FillinDocument")

* objDoc.Close _
* * * * * *SaveChanges:=Word.WdSaveOptions.wdSaveChanges
* objword.Quit
* Set objword = Nothing

I am trying to call a word macro from excel(office 2003) it keeps on
giving me errors.. can any one help


I think you have to state the workwook name, module name and macro
name
for example objwor.Run "Normal.NewMacros.FillinDocument"