Create a workbook with date as the name

Hi All,

I'm working on VBA code to create a new workbook with a name based on a date from the cell ("b3" for argument sake). Here is the challange. Date is stored with "/" separators and windows is not accepting "/" as the file name :/. Im quite happy with having "." as a separator in the file name or no separator at all (i.e 04022011). Is there any way of converting the date to a text format or anything just for sake of creating a file name?

Here is the code im using to get the filepatch and workbook name

Please Login or Register  to view this content.

Thanks in advance