Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls") | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Making excel macros run Word macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |