creating new excel workbook in code without opening excel
in [Word VBA]
|
From: BRC on 22 Dec 2009 15:58 Can anyone tell me if it is possible to create a new workbook with vba in word without opening excel. I have an excel template (myXLtemplate.xltm), I would to create a new file based on the excel template and save it to a new location. Working in office 2007. Thanks in advance for any suggestions.
From: Doug Robbins - Word MVP on 22 Dec 2009 16:46 See the article "Control Excel from Word" at: http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm and "How to speed up Word Automation by hiding the application" at: http://www.word.mvps.org/FAQs/InterDev/MakeAppInvisible.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "BRC" <brc1051-googrps(a)yahoo.com> wrote in message news:0c0b038d-8120-463e-aec9-ce84ecdaa03e(a)j9g2000prh.googlegroups.com... > Can anyone tell me if it is possible to create a new workbook with vba > in word without opening excel. I have an excel template > (myXLtemplate.xltm), I would to create a new file based on the excel > template and save it to a new location. Working in office 2007. Thanks > in advance for any suggestions.
|
Pages: 1 Prev: Cant change FirstPageTray of Word Document Next: Distribution of Word templates with macros |