Posts by pyrohac

    Re: VBA vs SAP


    Hi all,


    i have already solved this issue, maybe it will help someone:

    Code
    Set SapGuiAuto = GetObject("SAPGUI")
    Set SAP = SapGuiAuto.GetScriptingEngine
    With SAP.Connections(0).Sessions(0)
        .createsession
        .StartTransaction ("SAP FUNCTION")
    End With


    :thumbup:

    Re: VBA VLOOKUP - compare three columns


    Quote from nilem;620987

    Hi Pyrohac, try it


    Hi nilem,


    regarding first step "With Sheets("Sheet2")" is there any possibility to look up activesheet.name in external workbook? For example active sheet name is DK02, look up in another workbook the same name sheet and then apply what you have discribed?


    Hope it is clear.


    Thank you

    Hi all,


    i really need your help to write an macro, that will compare three columns from one sheet to another sheet, i will give you an example.
    Sheet1:
    A B C
    100000313 NORDIC CHARGE Service Charge IS Management
    100000313 NORDIC CHARGE Nordic Service Charges NO31
    100000627 NORDIC CHARGE Service Charge IS Management
    100000627 NORDIC CHARGE Nordic Service Charges NO31
    100001227 NORDIC CHARGE Service Charge IS Management
    100001227 NORDIC CHARGE Nordic Service Charges NO31
    100001988 NORDIC CHARGE Service Charge IS Management
    100001988 NORDIC CHARGE Nordic Service Charges NO31
    100002607 NORDIC CHARGE Service Charge IS Management
    100002607 NORDIC CHARGE Nordic Service Charges NO31


    Sheet2:
    A B C D
    100000313 NORDIC CHARGE Service Charge IS Management P12 2012
    100000313 NORDIC CHARGE Nordic Service Charges NO31 P11 2012
    100000627 NORDIC CHARGE Service Charge IS Management P11 2012
    100000627 NORDIC CHARGE Nordic Service Charges NO31 P12 2012
    100001227 NORDIC CHARGE Service Charge IS Management P12 2012
    100001227 NORDIC CHARGE Nordic Service Charges NO31 P09 2012
    100001988 NORDIC CHARGE Service Charge IS Management P08 2012
    100001988 NORDIC CHARGE Nordic Service Charges NO31 P05 2012
    100002607 NORDIC CHARGE Service Charge IS Management P04 2012
    100002607 NORDIC CHARGE Nordic Service Charges NO31 P03 2012


    I need macro, that will fill Column D from "Sheet2" to column D in "Sheet1" if values in columns A,B,C (together) in "Sheet1" will be found in columns A,B,C in "Sheet2". Is there any possibility to do this without using function "&" ????


    THank you, your help is much appreciated.