Sharing violation with pagesave to excel

[TomasThoren]

Hi Forum,

When I try to write data to Excel via the PageSave command and I have the Excel file open I get "Sharing violation"-error. This was not an issue when I was running Eviews12 (my collegues running Eviews12 doesn't have this issue either). However, when switching to Eviews14 it has become an issue.

I understand from similar threads that Excel has a tendency to lock files, but this doesn't seem to be a problem with earlier versions of Eviews. Does this has something to do with the new way of communcating with Excel that came with Eviews13?

The code I'm using for writing to Excel looks something like this:

Code: Select all

PageSave(t=excelxml,Mode=Update,noid, Cellfmt="Preserve") {%L_Sok_pro_lok}{%OmrKod}_inm_pro.xlsx nonames Range=Inmatning!A2 byrow @keep aromgang @Smpl 1 1

.

Kind regards
Tomas
Enterprise Edition - Oct 22 2024 build

[EViews Gareth]

It can happen if Excel is tied up, or EViews is unable to call Excel for some reason.