I read this forum all the time, but I'm new to posting, so please forgive any mistakes.
I just installed the October 29th Stata update, and now all my code involving the "putexcel" command is returning the "using not allowed r(101)" error.
Here's an example of my code that used to work fine:
However, even trying to recreate the basic examples in the manual ( for the command will produce this error. For example:
I realized that this is related to the recent updates to "putexcel", where you must now use "putexcel set" to specify the file for subsequent putexcel commands. This makes things easier in the long run (i.e., now you don't have to constantly re-specify where you want your cells to go, but it also has the (perhaps unintended) effect of making old code no longer work.
The options ", modify" and ", keepcellformat" also seem to produce errors when using just the "putexcel" command.
I've updated all my code so it now works, but I thought this might confuse others at first as well, so I thought I'd mention it here in case it helps!
Thanks!
-Evan
I just installed the October 29th Stata update, and now all my code involving the "putexcel" command is returning the "using not allowed r(101)" error.
Here's an example of my code that used to work fine:
Code:
fre c1checkweight if today_date - c1wgtdate < 8, nomissing include(0 1) matrix r2 = r(valid) if r2[1,1] == . { putexcel B10=("N/A") C10=("N/A") D10=("N/A") using "QC Template Weekly Progress Slide 2015-06-22", modify keepcellformat } else if r2[1,1] != . { putexcel B10=(r(N)) C10=matrix(r2[2,1]) D10=matrix( (r2[2,1]/r(N))*100 ) using "QC Template Weekly Progress Slide 2015-06-22", modify keepcellformat }
Code:
putexcel A1=(2+2) using file
The options ", modify" and ", keepcellformat" also seem to produce errors when using just the "putexcel" command.
I've updated all my code so it now works, but I thought this might confuse others at first as well, so I thought I'd mention it here in case it helps!
Thanks!
-Evan
Comment