I'm trying to define a math problem in excel, so for example a 4 cell block
where A1 contians nothing, B1 contains the number 2, A2 contains the '+'
sign and B2 contains the number 3, forming a simple addition fact. I want
to reference this block of cells as a record in access to print out a math
worksheet as a report.
Eventually I'll change the numbers in the problem to =int(rand()*10)+1 to
generate random addition facts, or any other type of problem and can form in
excel.
Bottom line: can I reference a named range as a field in a database record,
update that linked field in the original excel spreadsheet, and print out
that range, correctly formatted (maintaining the format from excel), in an
access report?
If possible, the named ranges could be of variable size, as I would use this
database to test students on a variety of math skills, record their
progress, and print customized tests for each student depending on their
individual progress.
Please help !!!