This project demonstrates a method of extracting system variable data from AutoCAD
and importing it into Microsoft Excel.
The application calculates the length of time a user has spent in a drawing session
and extracts this data to a timesheet created in Excel. It then totals the daily
drawing hours alongwith with the date, the draughtsmans login name, the drawing
number and the job number.
To use this VBA application, simply extract all of the files into your working
directory then load and run Timesheet.Lsp.
(If you have problems when writing or running this project, ensure that
the Microsoft Excel 8.0 Object Library is selected in your VBA References.)
After running the application, open the Excel file Timesheet.xls. |