Using the calculations of excel in a word macro

  • Thread starter Thread starter jvvbmacros
  • Start date Start date
J

jvvbmacros

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.
 
You need to create an excel object from word

Set exc = CreateObject("Excel.Application")
exc.Visible = True
 
Back
Top