Excel File Opener : String size limit reached: Strings are limited to 2147483648 bytes

[Zion777]

Hi There,

Can you anyone suggestion how to fix this attached issue. 

[Raj]

@Zion777 
if this is CSV convert it to excel and then try again.

hope this helps.

[jdminton]

@Zion777 You've posted a macro in your image of the workflow. Anything could be happening inside the macro. Are you able to share the macro here?

[Zion777]

I downloaded the macro from our Atleryx website itself, and tried to use my files path and tried.

[Zion777]

There are almost 300 plus .xlsx files which I am trying to access through Excel File Opener.

[jdminton]

@Zion777 Thanks for clarifying. You can see from the errors which records are not flowing through. I would look at one of those to see if they are in fact Excel files. I've gotten system generated reports sometimes that have .xls as the extension, but when you open, they are really .csv. As this macro only reads in .xls, .xlsx, .xlm, and .xlb files, that would be my first guess. What doe those erroring files look like when you open them in notepad?