Guys,
I am having difficulty in figuring out how to fix this error. The excel files are close and yet I am receiving error, "ERROR OPENING FILE.... "
My formula tool configuration are.:
1. Sheetname - '01-31-2021'
2 Filename - 'Recon Tracker - ' + [Sheetname]
3. Filepath - FileGetDir("......... ) + [Filename] + ".xls |||" + [Filename]
My output file configuration is
File Format - .xlsx
Output Option - Overwrite Sheet or Range
Tick the - Take File / Table Name from Field
Field Containing Filename or Part of the File Name - "Filepath (untick - Keep field in the output)
I hope you can help me find the solution on this matter as I can't really see what I am missing.
Thanks,
Mar
HI @danilang
The error message is "Error Output Data (255): Error Opening File [File Path and File name]. I've count and you're right, it is 260 characters including space. Is there a possible way to increase the length of characters? or any possible solutions if this is indeed the issue?
Looking forward for your reply.
Thanks
Mar
User | Count |
---|---|
105 | |
82 | |
70 | |
54 | |
40 |