pagesave with mode=update does not work

[fhespeler]

Dear all,

I attempt to save a alpha series via the command

pagesave(type=excelxml,mode=update) "C:\Users\fhespeler\Desktop\blhelp.xlsx" range="ticker!B1" @keep ticker

but is does not work. I checked for the existence of the file via

@fileexist("C:\Users\fhespeler\Desktop\blhelp.xlsx")

and got a 1 as a result, so the file clearly exists. Also if I exchange mode=update with mode=overwrite, the file is successfully overwritten. What can I do?

My EVIEWS version is EVIEWS 10+ Enterprise Edition

[EViews Gareth]

Could you define what "does not work" means?

I just tried a quick test, and it seemed to work fine.

Code: Select all

wfcreate u 100
alpha ticker = "hello"
pagesave(type=excelxml) myfile.xlsx range="b2" @keep ticker

ticker = "world"
pagesave(type=excelxml, model=update) myfile.xlsx range="b2" @keep ticker


[fhespeler]

The first command did not produce any saving results. Could it be that's due to the target file containing EXCEL Bloomberg formulas in another sheet than the target sheet?

[EViews Gareth]

Did you try my test program, and did it work?

[fhespeler]

Your testfile worked perfectly. It first produced a file with entries "hello" and then overwrote this with entries "world".