Sharing violation with pagesave to excel
Posted: Tue Jun 10, 2025 6:29 am
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:
.
Kind regards
Tomas
Enterprise Edition - Oct 22 2024 build
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 1Kind regards
Tomas
Enterprise Edition - Oct 22 2024 build