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
 

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

Back
Top