View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.