Thread: How do I add a month to a filename extracted from a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
  
Posts: 371
Default 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?
Reply With QuoteReply With Quote