Python Macro - Excel to PDF Converter Part 2

Question

Hi all!

I've been working with this Python Macro workflow that was populating the PDFs I wanted, but now it's no longer creating PDFs even though I'm not encountering any errors. Does anyone know what the problem may be? (I've checked all the file paths and they all seem to be correct)

Thank you!

Tax Form Filler.yxmd

f1042s_template.xlsx

f1042s_template.pdf

f1042s_filler.yxmc

taylormgruendel · Answer

Hi @PhilipMannering

It populated this message - Info: f1042s_filler (36): Record #1: Tool #5: AYX_PDF_form_fill() catch :  FileNotFoundError(2, 'No such file or directory')

Looked back at my Formula tool and realized the file paths were not generating a '\' before the pdf file, it works now! Thank you for your help :)

philipmannering · Answer

Hi @taylormgruendel

It looks like the bulk of the code is within a `try except` block. Which means any (ugly) errors are hidden. I would go to the workflow configuration pane > Show all macro messages,
Then rerun the workflow and look at the log messages. You may see the exact error... like "unable to open file ... because somebody has it open" .

Hope this helps.

taylormgruendel · Answer

Hey @PhilipMannering,

Thanks for the quick response! On our side, [f1_01] is set to a string already, and we double checked all of our absolute and relative paths. Do you know what else it could be?