Hello all. Is this possible. I have created a "calculator" in an Excel spreadsheet with certain formulas, vba, and if statements. Is it possible to simply create a new database, implement my excel calculator into an access form and use it in there with the same values and formulas set?...I have access 2007..Thanks
My objective is to be able to import information into a named table, use this calculator as the form (split form) for that table, call the information from the table into the footer of the split form and have that information populated in the foot reflect in the calculator based on the individual row that is selected in the footer; and the calculator would change based on which row the user chose at the bottom of the footer. It would more or less be a simple snapshot
Thanks..Brian
My objective is to be able to import information into a named table, use this calculator as the form (split form) for that table, call the information from the table into the footer of the split form and have that information populated in the foot reflect in the calculator based on the individual row that is selected in the footer; and the calculator would change based on which row the user chose at the bottom of the footer. It would more or less be a simple snapshot
Thanks..Brian
