Datasetting with a Makro in Excel

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Datasetting with a Makro in Excel

    Hello,

    i have got a problem to set Data into Palo.
    The result is #Null.

    The makro is working, but it seems to be that it cant get the connection to Palo.


    Sub Actuals_FSI_upload()
    '
    ' Budget_FSI_upload Makro

    '
    Dim currentCCrow As Integer
    Dim amountCCrows As Integer
    Dim errorRow As Integer

    errorRow = 64

    currentCCrow = 8

    Sheets("Eingabe Sheet").Select
    Range("M5").Value = "WAHR"
    Range("A8").Select
    Selection.End(xlDown).Select
    amountCCrows = (ActiveCell.row - 8)

    For x = 0 To amountCCrows

    Range("E4").Value = Range("A" & currentCCrow).Value

    If IsError(Range("E5").Value) Then

    Range("D" & errorRow).Value = Range("E4").Value
    Range("E" & errorRow).Value = Range("G46").Value
    errorRow = errorRow + 1

    ElseIf Range("E5").Value = "" Then

    Range("D" & errorRow).Value = Range("E4").Value
    Range("E" & errorRow).Value = Range("G46").Value
    errorRow = errorRow + 1

    End If

    currentCCrow = currentCCrow + 1

    Next

    'Upload beenden
    Range("M5").Value = "FALSCH"

    End Sub


    I checked the connection to Palo, and its connected.
    There is something i dont unerstand in that.
    The documentation i got here says i have to fill in the data to A8 by using the menu Palo --> Fill in Elements and select a titel on the left site "Costcenter". Is Palo able to insert data with this function?

    I hope someone can help me with it.

    Greetings,
    Christin