Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word Constants from Excel
I needed an Excel macro that would let the user enter information about a
client into a worksheet, then, with the click of a button, open a Word document that I had built that contained placeholders for the actual information. All the information from the worksheet needed to be inserted into the Word document and then the document needed to be printed. I recorded macros in Word for the replace and print functions. I copied those to the Excel macros and everything worked fined until it ran into this: wdPrintAllPages which is a Word constant and apparently, there wasn't way to access the Word constants from an Excel macro. Is that right? If not, how do I change "wdPrintAllPages" so that it will return that value in Excel. I was able to find the value of those in VBE for Word and simply hard coded them into my macros, but I was wondering if there were a more elegant way to do this. Thanks for any suggestions. Ken Loomis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word Constants from Excel
I have seen lots of code that uses latebinding mimic these values:
Const wdPrintAllPages as long = 0 so that the code is more self documenting. Ken Loomis wrote: I needed an Excel macro that would let the user enter information about a client into a worksheet, then, with the click of a button, open a Word document that I had built that contained placeholders for the actual information. All the information from the worksheet needed to be inserted into the Word document and then the document needed to be printed. I recorded macros in Word for the replace and print functions. I copied those to the Excel macros and everything worked fined until it ran into this: wdPrintAllPages which is a Word constant and apparently, there wasn't way to access the Word constants from an Excel macro. Is that right? If not, how do I change "wdPrintAllPages" so that it will return that value in Excel. I was able to find the value of those in VBE for Word and simply hard coded them into my macros, but I was wondering if there were a more elegant way to do this. Thanks for any suggestions. Ken Loomis -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word Constants from Excel
Hi Ken,
There are a few ways to do this. One is the method you used - replacing the constants with their literal values. Another is to set a reference to the Word object library via Tools | References. Once Excel has the object library reference, it will "know" the values of the Word constants. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Ken Loomis wrote: I needed an Excel macro that would let the user enter information about a client into a worksheet, then, with the click of a button, open a Word document that I had built that contained placeholders for the actual information. All the information from the worksheet needed to be inserted into the Word document and then the document needed to be printed. I recorded macros in Word for the replace and print functions. I copied those to the Excel macros and everything worked fined until it ran into this: wdPrintAllPages which is a Word constant and apparently, there wasn't way to access the Word constants from an Excel macro. Is that right? If not, how do I change "wdPrintAllPages" so that it will return that value in Excel. I was able to find the value of those in VBE for Word and simply hard coded them into my macros, but I was wondering if there were a more elegant way to do this. Thanks for any suggestions. Ken Loomis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word Constants from Excel
Thanks, Dave. That worked well.
"Dave Peterson" wrote in message ... I have seen lots of code that uses latebinding mimic these values: Const wdPrintAllPages as long = 0 so that the code is more self documenting. Ken Loomis wrote: I needed an Excel macro that would let the user enter information about a client into a worksheet, then, with the click of a button, open a Word document that I had built that contained placeholders for the actual information. All the information from the worksheet needed to be inserted into the Word document and then the document needed to be printed. I recorded macros in Word for the replace and print functions. I copied those to the Excel macros and everything worked fined until it ran into this: wdPrintAllPages which is a Word constant and apparently, there wasn't way to access the Word constants from an Excel macro. Is that right? If not, how do I change "wdPrintAllPages" so that it will return that value in Excel. I was able to find the value of those in VBE for Word and simply hard coded them into my macros, but I was wondering if there were a more elegant way to do this. Thanks for any suggestions. Ken Loomis -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Word Constants from Excel
Thanks for the help, Jake.
"Jake Marx" wrote in message ... Hi Ken, There are a few ways to do this. One is the method you used - replacing the constants with their literal values. Another is to set a reference to the Word object library via Tools | References. Once Excel has the object library reference, it will "know" the values of the Word constants. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Ken Loomis wrote: I needed an Excel macro that would let the user enter information about a client into a worksheet, then, with the click of a button, open a Word document that I had built that contained placeholders for the actual information. All the information from the worksheet needed to be inserted into the Word document and then the document needed to be printed. I recorded macros in Word for the replace and print functions. I copied those to the Excel macros and everything worked fined until it ran into this: wdPrintAllPages which is a Word constant and apparently, there wasn't way to access the Word constants from an Excel macro. Is that right? If not, how do I change "wdPrintAllPages" so that it will return that value in Excel. I was able to find the value of those in VBE for Word and simply hard coded them into my macros, but I was wondering if there were a more elegant way to do this. Thanks for any suggestions. Ken Loomis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Constants in Excel | Excel Discussion (Misc queries) | |||
vba constants for excel | Excel Discussion (Misc queries) | |||
Accessing Word constants in Excel | Excel Programming | |||
accessing constants like msoBarTypeMenuBar | Excel Programming | |||
Accessing Word from Excel | Excel Programming |