Using the calculations of excel in a word macro
Is it possible to manipulate lines of a word document using cell
values created in an excel spread sheet (combine macros from both word and excel? At a first try in pasting part of an excel macro into word, the word macro won't compile items from excel, such as range selection. I'd like to create different versions of a test by changing the order of the questions and the location of the correct response based on tables created in excel. |
Using the calculations of excel in a word macro
You need to create an excel object from word
Set exc = CreateObject("Excel.Application") exc.Visible = True " wrote: Is it possible to manipulate lines of a word document using cell values created in an excel spread sheet (combine macros from both word and excel? At a first try in pasting part of an excel macro into word, the word macro won't compile items from excel, such as range selection. I'd like to create different versions of a test by changing the order of the questions and the location of the correct response based on tables created in excel. |
All times are GMT +1. The time now is 07:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com