Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
Excel project, need help | Excel Discussion (Misc queries) | |||
Excel project, need help | Excel Discussion (Misc queries) | |||
Is Excel the way to go for this Project? | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) |