| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time decision for open file in Excel
if 20 hours before current time is today,then open file A
if 20 hours before current time is yesterday,then open file B, use below formula can work if (NOW ()-TIME(19,59,59)<TODAY (),"Y","N") but how to change it as excel macro such that "Y" become "open file A" and "N" become "open file B". Can I use IF ...THEN...to do this? thx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decision Matrix with multiple criteria and decision | Charts and Charting in Excel | |||
| When i open excel file it takes time to open | Excel Discussion (Misc queries) | |||
| Can Excel open a new application every time you open a file? | Setting up and Configuration of Excel | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
| Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel | |||
Threaded Mode
