It would theoretically be possible to pop up a VBA form, enter the data there, and have the input stored in a VBA data provider right within the document. Possible, but far from trivial. Actually, we have similar requirements, but chose to solve it from the opposite direction. Use Excel as the front-end, and get data from BusObj behind the scenes using the techniques outlined here … Using BusObj Reporter/DeskI as data source for Excel/Access.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)