Unable to save Excel workbook after running macro

(0) Share

Report

Posted on by vp-pengu1n

Hi!

I have an excel sheet where I want to insert an object (PDF-file) - for this I created a macro which works fine (in terms om inserting the object as a pdf in the excel worksheet). However, when I'm about to save the file I get error message "Error where detected while saving... Excel may be able to save by removing or repairing..."
If I do these steps manually with PAD - insert - object - file - ok.. it works fine but I would rather speed up the process using the macro. Anyone has an idea? Also encountered same error message when I wanted to update a cube in excel (which was not related to a macro, just pressing refresh witch PAD made it impossible to save the file but doing manually worked fine).

Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

kinuasa 801 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Does the same error occur when the macro is executed from another book, as in the code below?

Public Sub Sample() With Application.Workbooks.Open("C:\Test\Excel\AddOLEObject.xlsx") With .Worksheets.Add .OLEObjects.Add Filename:="C:\Test\PDF\TEST.pdf", Link:=False, DisplayAsIcon:=False End With .Save .Close End With End Sub

Was this reply helpful? Yes No
vp-pengu1n 60 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, seems to be working that way!

Was this reply helpful? Yes No