excel project
im not sure if this is possible in excel... but here's what my bos
wants... one excel file (master file) contains 10 command buttons (sheet 1) when a user clicks on a button (button 1), an excel template fil (template 1) is automatically opened... now this template file will be filled up by the user, and once she/h saves the template (template 1) with a new filename, the date and tim (of saving) will be listed on the master file (sheet 2) together wit the specified filename of the user. now if the user clicks on button 2, template 2 is opened. and then onc saved, the date,time and filename will be recorded on the master fil sheet 3... and so on... can anyone help me do this? please... thanks! -summe -- Message posted from http://www.ExcelForum.com |
excel project
Sounds like you would need to instantiate application level events with the
master workbook to capture the saveas. See Chip Pearson's page on this http://www.cpearson.com/excel/AppEvent.htm -- Regards, Tom Ogilvy "summer" wrote in message ... im not sure if this is possible in excel... but here's what my boss wants... one excel file (master file) contains 10 command buttons (sheet 1). when a user clicks on a button (button 1), an excel template file (template 1) is automatically opened... now this template file will be filled up by the user, and once she/he saves the template (template 1) with a new filename, the date and time (of saving) will be listed on the master file (sheet 2) together with the specified filename of the user. now if the user clicks on button 2, template 2 is opened. and then once saved, the date,time and filename will be recorded on the master file sheet 3... and so on... can anyone help me do this? please... thanks! -summer --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 11:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com