Error Opening File - Output Tool

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

Error Message

Output

Common Use Cases

Accepted answers

All comments

Luke_C

In your filepath try putting xlsx instead of just xls.

KamenRider

Thanks @Luke_C . I've change the extension to xlsx but same error receive. any more ideas?

Hoping to hear from you.

Thanks,

Mar

KamenRider

Hi All and @Luke_C

I noticed that every time I added a date, it gives me an "Error Opening File". I'm not sure but is there any reason? Please provide me a sample formula using this name "Associated Tracker" + Date".

Please assist.

Thanks,

Mar

KamenRider

I also notice that every time I add a space or underscore "_" to Recon Tracker to look like this Recon Tracker_01-31-2021" ("Recon Tracker_" + [SheetName] + ".xlsx|||Sheet1"), this gives me an error file opening but when I remove the special character which will look like this "Recon Tracker01-31-2021", it generated an output file. I can't understand what do I miss. Please help.

Thanks,

Mar

danilang

@KamenRider

All of these things are working for me. Please post a sample workflow that demonstrates the problem

Dan

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703