Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in Excel that work with Word - 2003
Hi !!
I need to do prepare a list from available Excel Workbooks and then do a Mailmerge with a Word Document all with a Single Macro written in Excel VBA. Can someone tell me how I can do it ? Thanks !! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in Excel that work with Word - 2003
Hi Vijay
see: http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/faqs/interdev/E...ateBinding.htm HTH -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in Excel that work with Word - 2003
"Helmut Weber" wrote: Hi Vijay see: http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/faqs/interdev/E...ateBinding.htm HTH -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" Hi Helmut !! I have saved the two pages you had given URL's for, in your message. Thank you very much !! I 'll try the Createobject method to do the job. I have not been very successful till now but I'll try again. THANK YOU ! BEST WISHES ! Vijay |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in Excel that work with Word - 2003
One problem I'm running into with early binding now is version
compatibility. If you include a reference to the object library of an earlier version of office, open the project in a later version without the previous version installed (say 2007 opening a 2003 project, and no 2003 on the machine present) this reference becomes converted to Word 12 object library (equivalent 2007). Once opened back in 2003 (without an install of 2007 on the same machine), you'll run into a "reference not found" type error. However, CreateObject will continue working. On Jun 18, 5:50 am, Vijay Chary wrote: "Helmut Weber" wrote: Hi Vijay see: http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/faqs/interdev/E...ateBinding.htm HTH -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" Hi Helmut !! I have saved the two pages you had given URL's for, in your message. Thank you very much !! I 'll try the Createobject method to do the job. I have not been very successful till now but I'll try again. THANK YOU ! BEST WISHES ! Vijay- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in Excel that work with Word - 2003
That's why it's prudent to convert the project to late binding before
distributing it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ilia" wrote in message ups.com... One problem I'm running into with early binding now is version compatibility. If you include a reference to the object library of an earlier version of office, open the project in a later version without the previous version installed (say 2007 opening a 2003 project, and no 2003 on the machine present) this reference becomes converted to Word 12 object library (equivalent 2007). Once opened back in 2003 (without an install of 2007 on the same machine), you'll run into a "reference not found" type error. However, CreateObject will continue working. On Jun 18, 5:50 am, Vijay Chary wrote: "Helmut Weber" wrote: Hi Vijay see: http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/faqs/interdev/E...ateBinding.htm HTH -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" Hi Helmut !! I have saved the two pages you had given URL's for, in your message. Thank you very much !! I 'll try the Createobject method to do the job. I have not been very successful till now but I'll try again. THANK YOU ! BEST WISHES ! Vijay- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions | |||
Getting embeded Excel worksheets with macros in Word to work | Excel Discussion (Misc queries) | |||
Getting embeded Excel worksheets with macros in Word to work | Excel Programming | |||
macros in excel 2003 won't work in 2000 | Excel Programming | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |