Dear all,

I am writing to ask for a problem on the putexcel modify. I have an existing excel xls. file which is generated using a different data set. I was trying to use putexcel to add new data to this existing file. The code I use is:

putexcel set filename.xls, sheet("Sheet1") modify open
putexcel A1 = ("Table 7: Empirical Research")

However, the error message says "workbook filename.xls could not be loaded. r(603)"

I also used multiple ways to change directory using the code:

putexcel set "C:\A\B\filename.xls", sheet("Sheet1") modify open
putexcel A1 = ("Table 7: Empirical Research")

Now the error message changes to "could not write to file. r(691)"

With little information in the error message, I could not find the problem here.

Thank you so much in advance!

Best regards,
Scarlett Ling