By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,158 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,158 IT Pros & Developers. It's quick & easy.

Linked excel spreadsheet - multiple cells

P: n/a
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 !!!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.