Set cell value in Excel .xlsm file

Dylan

New Member
Hello everyone,

I already completed the official documentation (those 200 pages) and also done 2 processes, but now I have a problem writing a value that is stored in a data item into an Excel file. These are the steps followed:

1) Create instance
2) Open workbook
3) Show workbook
4) Worksheet exists?
5) Activate that worksheet
6) Set cell value
7) Save workbook
8) Close workbook, saving it
9) Close instance

The funny thing is that if I walk through those steps pressing F10 in each one, it works perfectly. But if I put those steps in a page and run the entire page with just one F10 it writes the value in the cell but, when I open the workbook, the value is not written (i.e, the 'save workbook' doesn't work right).

What can I do? Maybe adding some 'waits'? I really need you help.

Thanks
 
Top