read the columns of worksheet and set any data in the colums named with "Date" in the title to format "dd/mm/yyyy"

[joeloyzaga]

I know to use _Excel_RangeRead to read the Column titles by: getting the list of Worksheets using  _Excel_SheetList, open each worksheet etc etc but could I do it by using _Excel_RangeFind. Anyway I don't know the command to set the Range to "dd/mm/yyyy"

Could anybody give me an example above? - setting the formatting please

 

Joe

[computergroove]

Maybe this:

@MDAY & "/" & @MON & "/" & @YEAR

Some example code and a snippet or example excel worksheet would be helpful for us to test here.

[joeloyzaga]

I actually don't know how to set the formatting in autoit - I know how to set it in vbs like this 

Set NewWorkBook = oEngine.Workbooks.Add 
NewWorkBook.SaveAs(NewXL) 
Set WorkBook = oEngine.Workbooks.Open(NewXL) 
Set InitSheet = WorkBook.Sheets.Item(1) 
    With InitSheet 
           .Range("A1","A1").NumberFormat = "@"
            .Range("A1:ZZ1").Font.Color = RGB(218,225,130)
            .Tab.ColorIndex=53
            .Cells.Font.Name = "Comic Sans"
            .Cells.Font.Size = 12   
            End With

[computergroove]

I dont know vbs. In these forums we are more focused on pushing you in the right direction rather than writing the code for you. If I ask for come code snippets it's because I need to have something that is relevant to your problem that I can test from my side to get it to work. In your first post I am not sure if you are looking for a column or row or header or tag or whatever. Obviously the syntax is different for the autoit code for different data locations.

[water]

Translating VBS to Autoit isn't too hard:

; $oWorkbook is returned by _Excel_WorkbookOpen etc.
With $oWorkBook.ActiveSheet 
    .Range("A1").NumberFormat = "@"
;    .Range("A1:ZZ1").Font.Color = RGB(218,225,130) ; RGB is a VBS function and not available in AutoIt. If needed I can provide an example
    .Tab.ColorIndex=53
    .Cells.Font.Name = "Comic Sans"
    .Cells.Font.Size = 12   
EndWith