Share via

Save pdf issue after microsoft update

Anonymous
2024-05-27T22:06:16+00:00

Hi,

I recently open my macro to convert an excel file to pdf, previously it was working fine. But with the Microsoft updates few months ago, it created an issue on my workbook.

See below part of the macro code.

Sheet1.Range("B5:AE63").ExportAsFixedFormat Type:=xlTypePDF,

This part of the code is creating a Run-time error '-2147018887 (800717779)':

Document not saved.

I found out that if I change the Range(("B5:AE63") to Range("B5:Z63") it would fix the issue, but the problem is that it would convert only part of the excel sheet to pdf.

Please let me know how to fix this issue.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-28T00:59:10+00:00

    Could you share a test file to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Was this answer helpful?

    0 comments