Monday, July 27, 2015 – Permalink –
Access Data-Excel Spreadsheets
Distribute to everyone
Many times an office will provide Excel for all users, but not want or need to also install Access on every desk.
Helen Feddema has laid out a method to use the data in an Access database to create Excel workbooks. These workbooks can then be e-mailed to employees to be used to record time spent on projects.
The code provided is above the entry level user, but understandable.
There is a downloadable file that includes the instructions and samples of the Access and Excel files.
Go to Access Archon Columns from Woody's Office Watch.
The pertinent file is down near the bottom of the page. Look for article 127 and download accarch127.zip.
See all Topics excel
<Doug Klippert@ 3:52 AM
Comments: Post a Comment