I have excel file with extension is .xlsm and was opened by using Excel application scope
for each transition in excel I should add value in Remark column
by using write cell i am trying
but getting this error like its workbook but file.xlsm
Please let me know the solution.
Use excel application scope and write cell from excel activities and try again
but did the same thing, but still getting error
TempSheetName is a value get from other spreedsheet? if so, make sure you don’t close this sheet before paste value to another one.
But as my code designed like it always close excel file . when ever its open excel for example
in our every process we are using in this format for config file
as per config code whenever we are open config file it automatically close the excel file.
Hi @rikulsilva ,
i was tried this ,but still getting the sam e error.
Try put delay activity before write the value with 1 second, just for debugging purpose
will you please explain in step wise please
i am not able to see continue error
Try log the TempSheetName in Log Message Activity before Write Cell to see it value. Also try put hardcode value in Write Cell to isolate where problems occurs
can you try with modern activities instead?
did you try using the write woorkbook cell activity?
Can you tell what is the system package version and studio version…Did you try changing it?
And is the file your trying to read is proper…Can you print the filename and sheetname variables you are using and check…Please try with visible property unclecked
Also try removing save and use a save workbook activity instead
Hope this helps
STUDIO version 2020.10.6
Please let me know is there any other way to add row(count+1) Values.
without using Write cell
Hi @fernando_zuluaga ,
No because it macro sheet .xlsm
it don’t work in workbook.
Please let me know is there any other way to add row(count+) Value.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.