Hi,
Is it possible to have a "live update" of Jet numbers?
I am aware of the planning tool that can allow me to send e-mails automaticly, however I would like to have a live update on a "big screen" in our company.
Kind regards
Date
Votes
2 comments
-
Harry Lewis Hello Poul -
It is possible to access some of the Jet Excel add-in's features through Visual Basic for Applications. Using that capability, you could create a report (either a normal report or one that is in Dashboard Mode) and - using VBA - refresh the data in the report at regular intervals.
Keep in mind that - because macros can (in some cases) interfere with the workings of the Jet Excel add-in - any support requests regarding such a report would need to have the macros removed before submitting.
-
Poul Majvig Sørensen Thank you for the swift reply.
I will look into the VBA
Please sign in to leave a comment.