Exporting Excel to Word

[Guest]

I hope this is the right place to post this question.

I create test for new hires at my current job. Now, each class has it's own
pace, so the test are never the same. The questions remain the same, but may
show up on test 2 for class A, and then be on test three for class B.

I would like to simplify the process of creating a whole new test each day,
by creating an excel spreadsheet of questions. Then at the end of class I can
check what categories, I went over that day and have it imported to word.

To explain this a little more;

Row A in excel may have terms. Row A Col 1 may have Term one, Row A Col 2
may have Term two, etc. We have about 20 terms to go over, but on one single
test I may one put 5 or 7.

It would be able to check that I want terms on this test, and choose how
many term of the 20 I want. So I will insert a value, and have it randomly
select 5 out of the 20 terms.

I will then have row B have problem solving questions. I may create 10 story
problems on Row/Col B/1, B/2, Etc.

So, depending if we go over terms and Story problems I can check witch rows
to gather questions from, and how many I want on the test.

One I have chosen the questions for the test, I would like it to export to a
Word document to be printed.

Is this possible?

Is there any documentation to set something like this up?

I know basic VB6 programming, should I setup an interface that atchieve what
I want?

I hope someone can help.

Regards,

LmB

 

[Guest]

You probably could do that, but it would be easier to simply copy the
selected items to a new Excel sheet and then print that sheet in Portrait
without gridlines visible. It looks like a word product but eliminates the
cross application headache.