View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kris_Wright_77 Kris_Wright_77 is offline
external usenet poster
 
Posts: 24
Default GetObject to Open Word containing Macros


From examples of retrieving information held with a Form in Microsoft Word, I
have a macro that opens up a collection of forms to update a register held
within Excel

It all works provided that either the word forms do not contain macros or I
sit there and click Disable or Enable Macros for every form.

Is there any way to tell Word to Get the forms without activating the Macros?
- Or always activating them as it makes no difference to the information
being retrieved and wont be run by just opening

Set Wd = GetObject(Range("RFI_Location").Value & ImportForm)
where RFI_Lacation is the Filepath & ImportForm is the Filename (from a
macro that seaches the Filepath for the forms)

Is there another method that I should use, if GetObject isnt the right one?


Thanks very much for any help that anyone can give.

Kris