Hi,
What I am trying to do is to gather one specific sheet from all files that may have these file types (xlsx, xlsm, and xlsb ) and output them in the same file type after the workflow has done its data blending. I have no problems doing this with xlsx and xlsm but..
How do I this with .xlsb files?
I am getting this error:
Error: Output Data (128): Error creating table "'Sheet1$'": Microsoft Access Database Engine: ''Sheet1$'' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.\3125 = -537199594
My configuration looks like this:
The Field name PATH looks like this:
There are no problems with this formula on xlsm and xlsx.. just the xlsb files.
Any help would be greatly appreciated.
Thanks
