We have created 4 complex Excel spreadsheets with computations (no data) that we don't want to reprogram in Access. I am hoping we can open the Excel spreadsheets, and use them in the Access program as calculators: write to a few input cells, and read back the result from the output cell. These spreadsheets need to be packaged with a runtime Access program, and the exchange between Access and Excel has to happen in the background without the users knowledge or intervention.
-
-
That is a great deal of programming, that is very likely to break easily.
It would be well worth the time to create procedures to do the calculations in Access.
Don't get me wrong, it can be done, but the accuracy of the data will come into question at some point, if something get's moved on the sheet, or something changes, that breaks the whole program.
Just keep that in mind?
The easiest way to do that is to create a class module that will have all the values that you want, and how they are calculated. Translating them into access wouldn't be that difficult if you simply spend the time to create it. This way, you can enter values in, and it will calculate values out based on the input.
If you need code examples, I'm more than willing to show you how.
Hope that helps,
Joe P.
Comment