| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can the date be automated?
Before I could run my program, there are 2 places in it where I have to edit
to show the current date (weekend dates excluded). Is there a way to get around it so that each time when the program is run, the date quantity (different format) is automatically increased by one on a week-day but by three on a week-end? Those two lines are as shown below: ActiveCell.FormulaR1C1 = "=DATE(2007,4,20)" ' <- Current date ActiveCell.FormulaR1C1 = "=OPEN(""D:\Chart\20070420.TXT"",,,2)" ' <- Current date Thank you if you can help. Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated calculations? What's the best way? | Excel Discussion (Misc queries) | |||
| Automated printing | Excel Discussion (Misc queries) | |||
| Excel 2002 automated annual date change | Excel Discussion (Misc queries) | |||
| Run automated macros | Excel Discussion (Misc queries) | |||
| Automated Linking | Excel Discussion (Misc queries) | |||
Threaded Mode
