DataManagerFilesUpload in EPM sp24

[Former Member]

My coworker built a file upload macro using the VBA code below. This code works perfectly for all the users on Client20, but doesn't work for me on Client24, instead it crashes excel every time I try and run it. Its not security related because I can upload a file manually on my version of the client, and run this macro from another machine using client 20.

I'm wondering if anyone else has seen this issue?

Code:

Sub File_Upload()

     Dim EPM As New FPMXLClient.EPMAddInAutomation

     Dim Team As String

     Dim SFolder As String

     Dim FilePath(0) As String

     Team = "Your Team ID"

     SFolder = "Your SubFolder"

     FilePath(0) = "Your File Path"

    EPM.DataManagerFilesUpload Team, SFolder, FilePath

End Sub

Thanks, Ryan

[former_member186338]

Sorry, but can you provide your real code?

Vadim

[Former Member]

Sub File_Upload()

    Dim EPM As New FPMXLClient.EPMAddInAutomation

    Dim Team As String

    Dim SFolder As String

    Dim FilePath(0) As String

    Team = "ADMIN"

    SFolder = "DATALOAD"

    FilePath(0) = "\\ttcfile05\BI Operations\ScenarioLoad.csv"

    EPM.DataManagerFilesUpload Team, SFolder, FilePath

End Sub

Again the key here is that it works in sp20, but fails in sp24.  I can also manually upload the file using the normal dialog, so it seems to be a possible bug 24.

There is no screenshot I can show of the error, as it simply crashes Excel2013

[former_member186338]

I have no system in front or me to test... Can you show function definition of DataManagerFilesUpload in VBA Object Browser?

[Former Member]

Sorry for the delay, hopefully this provides you the answers you're looking for. 

[former_member186338]

"I can also manually upload the file using the normal dialog" = from this location:

"\\ttcfile05\BI Operations\ScenarioLoad.csv"?

I can't find anything wrong with your code...

Try to install EPM SP23 to see the SP effect...

Vadim