Macro Code Modification

[zaska]

Good Evening All.

I have a problem with the recorded macro code.

ChDir "E:\Macros\Input"
    Workbooks.Open Filename:="E:\Macros\Input\cm08APR2011bhav.csv"

ChDir "E:\Macros\Output"
    ActiveWorkbook.SaveAs Filename:="E:\Macros\Output\cm08APR2011bhav.txt", FileFormat:=xlCSV _
        , CreateBackup:=False

I cannot use this Macro Code The next day because the Input csv file name changes. to " cm09APR2011bhav.csv "

How can i modify this code so that i can use the recorded macro daily irrespective of the date

 

[VoG]

Then maybe

Workbooks.OpenText Filename:="E:\Macros\Input\MTO_" & Format(Workbooks("NSE Converter.xls").Sheets("Sheet1").Range("A1").Value, "ddmmyyyy") & ".DAT", Origin:=437, _
        StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
        ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True _
        , Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
        Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True

 

[zaska]

Thank u a lot

It's working..

Do u mind asking few more questions..?

How do i extract all the four input files using VBA code if the .csv and .DAT files are zipped.

 

[VoG]

Try starting a new thread for that - I don't know.

 

[zaska]

Thank u for the kind support