Using the calculations of excel in a word macro

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.
 
J

Joel

You need to create an excel object from word

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top