Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save As
I have made a custom icon that will eventaully Save a copy of the workbook in
a specified location. Since I am so new to macro and MVB programming, I am need of some serious help. First of all I made a User Form that is a pop-up window that will display which shift the workbook should be saved as "Days" or "Nights". If the "Days" button is clicked then I want a copy of the current state of the workbook saved to "D:\2008\Days\*" If "Nights" is clicked then of course it will be in "D:\2008\Nights\*". * will be "Days Cost" or "Nights Cost" then following this will be today's current date. i.e. if I save it today then it will be saved as "Days Cost 11-23-08" or "Nights Cost 11-23-08", if I save it tomorrow it will be saved as "Days Cost 11-24-08" or "Nights Cost 11-24-08" I also don't know how to get the custom icon in my toolbar to open up the pop-up window when it's pressed. Is any of this possible? I know it's easier to simply go through the motions of using the File Menu but I have posted step-by-step instructions on how to save the file with pictures and still it continues to be messed up. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) |