PureBytes Links
Trading Reference Links
|
Hi
As LAL said VBA routine is best. As I am just learning VBA cant help
much in VBA.
However the following is a macro to insert date in M2 for all the rows
containing data.
Incase u need date in some other celll other than M2 then change M2 in
the macro to the desired cell address for eg B2:B in case u need in
date in Column B
The macro is:
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Dim MAXCNT As Integer
MAXCNT = Selection.Rows.Count + 1
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("M2").Select
Selection.NumberFormat = "[$-409]d-mmm-yy;@"
Range("M2").Select
Selection.AutoFill Destination:=Range("M2:M" & MAXCNT - 1)
End Sub
I hope it helps
--- In amibroker@xxxxxxxxxxxxxxx, "Eugene" <eugenecpinto@xxx> wrote:
>
> I have multiple csv files with 15 columns of data
>
> It is missing a date column which is contained in the file name
>
> Is there anyway we can add a column to the csv file with the date that
> is contained in the file name in dmy format
>
> TIA
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.1/640 - Release Date: 1/19/2007 4:46 PM
|