In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error Opening File - Output Tool

KamenRider
11 - Bolide

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

10 REPLIES 10
KamenRider
11 - Bolide

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

Labels
Top Solution Authors