Problem in opening .Csv file using VB

[zaska]

Hi all..

I am having problem in opening the .Csv file..Kindly help in coding with the correct date format in my code..

File Name :   BANK NIFTY11-04-2011-11-04-2011.csv

"E:\Macros\Input\BANK NIFTY" & Format(Workbooks("NSE Converter.xls").Sheets("Sheet1").Range("G2").Value, "ddmmyyyy") & ".csv"

 

[zaska]

Can anyone help with this simple code??

 

[Joe4]

I would recommend that you wait more than nine minutes before bumping your own posts. Otherwise, it will no longer show up on the list of question with no replies.

It looks like you are using a Date format of "ddmmyyyy" when you really want "dd-mm-yyyy". The format should look exactly like how you want it to appear, dashes and all.