| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a month to a filename extracted from a cell
Hi, I have a cell containing a date in the format ddmmyyy (South African
format) eg. 28/3/2006. I want to extract from this cell the value of the month and year as "March 2006" and then use it to save the workbook name in a folder as ("C:\Data\Import March 2006.xls"). Any ideas how to do this in code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to sum values extracted from string | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| how can the necessary information be extracted? | Excel Discussion (Misc queries) | |||
| Formula That Totals Extracted Values | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
