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 -

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

Isnt anybody here who can help me?

Niemand da, der mir dabei helfen kann?

Thanks