Unanswered

Problem: Convert Excel macro-enabled XLSM file to PDF

(0) Share

Report

Posted on by YatinMumbai

123

I have a Excel macro file (workbook) which requires to be uploaded to OneDrive for Business and converted to PDF. Trigger is When a file is created. Then using standard Convert File action (PDF format) and then Create File which does not give any error. However, the created PDF file has 0 bytes and does not open as a PDF in browser or Acrobat Reader.

I have also tried to save the file as XLSX (non-macro) file, but same result.

One reason for the problem may be that the file has multiple worksheets (about 15). I have defined a Print Area in the Excel. Also, I have a Name Range defined for the area I want to print. Not sure what will help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @YatinMumbai ,

Have you tried using Get file content action or Get file metadata to get the file size and File content?

See if its file contents can be referenced normally and if the file size is as expected.

In addition, you can create a simple Excel file to perform a similar test and see if such errors also exist. The purpose of this is to confirm whether this is related to the reason for the problem you mentioned.

Best Regards,

Was this reply helpful? Yes No
YatinMumbai 123 on at

Like (0)

Report
UPDATE:
After a of tinkering I found the issues that prevent Excel to PDF conversions (using OneDrive Convert File action).
Remove all of the the following - Macros, Modules, Buttons.
Remove all Connections. In 2 worksheets I had a table linked to a SharePoint list causing fail.
Both of the above can be done from VBA code (in Save As macro).
Save the file as XLSX file. (FileFormat:=51)
Issue still present:
You cannot select a single worksheet to print.
It is better to have created Print Area for each worksheet since all worksheets will printed to PDF.
If your sheets are a mix of Print Area as portrait and landscape orientation, the conversion will have only the orientation of the first sheet. All other orientation settings will be ignored. If you use a third party PDF converter like Muhimbi, this is taken care of.

Was this reply helpful? Yes No