Posts by MrRedli

    hi guys,


    Can you please tell me what the below code of line do and does it mean?



    Code
    1. Private Const EXCHIVERB_REPLYTOSENDER = 102
    2. Private Const EXCHIVERB_REPLYTOALL = 103
    3. Private Const EXCHIVERB_FORWARD = 104
    4. Private Const PR_LAST_VERB_EXECUTED = "http://schemas.microsoft.com/mapi/proptag/0x10810003"
    5. Private Const PR_LAST_VERB_EXECUTION_TIME = "http://schemas.microsoft.com/mapi/proptag/0x10820040"
    6. Private Const PR_SMTP_ADDRESS = "http://schemas.microsoft.com/mapi/proptag/0x39FE001E"
    7. Private Const PR_RECEIVED_BY_ENTRYID As String = "http://schemas.microsoft.com/mapi/proptag/0x003F0102"

    hi guys,


    Can you please help me I need to convert text which is saved as DDD MM DD to actual date. so for example I need "Mon Feb 05" to be converted to 05/02/2018 or "Sun Feb 05" to be shown as 05/02/2017.

    hi guys,


    can some one help me? attached sample file. I am looking for formula which will sum based on month in b2 from all sheets. I have got formula which works fine for 1 sheet but can not make it work with all sheet.


    the original file has over 20 sheets which I am trying to add up. and has data over 5yrs.

    Files

    • Sample.xlsx

      (11.48 kB, downloaded 92 times, last: )

    Re: Macro to allow location and change file type to XLS


    I have the below code (from Ron de Bruin website) which I have tried to modify but I get type miss match on "Sheets(Array(Output1, O2)).Copy" line. Can someone look into this?


    hi guys,


    Can someone help me, I am looking for a code which will copy output1 and output2 tab from existing worksheet into new worksheet and save the file as XLS.


    it should also give the user option to save the file in user define folder and name as they need.


    below is my attempt but its does not work and keeps crashing on "Worksheets(Array("Output 1", "Output 2")).Copy"


    hi guys,


    I need a macro which will create column based on the next month days excluding weekends. and copy values from pervious day of the week into new date. (attached sample)


    Below is step when the button is pressed.

    • find which is the last month already been created. is attached its August.
    • then create new column for each of the month for Sept excluding weekend (so it will create 21 column) and add sum column at the end which total for the month.
    • copy value from last week of pervious month based on day of the week into the new month. So for example copy 1st Sept will copy values from 25th Aug which last Friday of the month of Aug.
    • all formulas need to remain and updated as new columns are added in. I have added a column showing which cells are values for reference. So when coping data it need to only copy the values and all formula will remain in place.
    • the total column formula will need to be updated based on days in the month and so will the formula in row 1.


    hope I have explained this well.


    I have paid 10% already to OZgrid will pay $25 AUD to person who completes the task. Need this done by Friday Morning 7/07/17.

    Re: Transpose data from one sheet to other in particular format - AUD $20


    also just the output 1 format is not right, there are 4 rows created instead of one


    [TABLE="width: 552"]

    [tr]


    [TD="class: xl67, width: 92, bgcolor: transparent"]Date
    [/TD]
    [TD="class: xl68, width: 92, bgcolor: transparent"]Time
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Import kWh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]import kVArh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Export kWh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Export kVArh
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]21
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]21.112
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]42
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]10.476
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [/TABLE]


    this should show as below:



    [TABLE="width: 474"]

    [tr]


    [td]

    Date

    [/td]


    [td]

    Time

    [/td]


    [td]

    Import kWh

    [/td]


    [td]

    import kVArh

    [/td]


    [td]

    Export kWh

    [/td]


    [td]

    Export kVArh

    [/td]


    [/tr]


    [tr]


    [td]

    19/05/2015

    [/td]


    [TD="align: right"]12:30 AM[/TD]
    [TD="align: right"]21.112[/TD]
    [TD="align: right"]10.476[/TD]
    [TD="align: right"]21[/TD]
    [TD="align: right"]42[/TD]

    [/tr]


    [/TABLE]