Print_Area name conflict when loading through Workbooks.Open API

Add-in Express™ Support Service
That's what is more important than anything else

Print_Area name conflict when loading through Workbooks.Open API
 
gui




Posts: 13
Joined: 2016-05-11
Hi,

I sometimes get this error (Print_Area name conflict) when I use the following code in my add-in:
ExcelApp.Workbooks.Open(MyWorkbook)

The goal is to load another workbook.

User added an image

Seems to be related to different naming of the Print_Area (when it is defined).

Any idea to avoid the message when ExcelApp.Workbooks.Open is used?

Thanks!
Posted 29 Mar, 2018 15:46:19 Top
Andrei Smolin


Add-in Express team


Posts: 15738
Joined: 2006-05-11
Hello,

Please check the explanation at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_365hp/name-conflict-old-name-printarea/4145041c-950c-4923-a4f9-68c459a1ce0e.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Mar, 2018 03:54:27 Top