Hello everyone,
I have already done some processes (including all the official tutorials that are in that pdf of 200 pages that I don't remember the name), but today I faced a problem that never happened to me and I couldn't fix it:
I need to paste the information that is in a data item into a cell of a .xlsm Excel file. So, I made a page in the process with the following steps:
1) Create instance
2) Open workbook
3) Show the workbook
4) Check if the worksheet were I want to paste the information exists
5) Activate worksheet
6) Use the Set Cell Value from the MS Excel VBO
7) Save the workbook
8) Close the workbook (saving it again)
9) Close all instances
I already checked that the file is macro-enabled.
When I run it step by step (i.e, pressing F10 on each action), it works perfectly. But when I run the page in just one F10 hit (remember that it's in a page, so I run the page completely with a F10 from the main page), it writes the value in the cell but then, when I open the workbook, the value is not posted. So, I suppose that the Save workbook is not working. But when I run it step by step it works perfectly! It has no sense for me, and I don't know what to do.
Can anyone tell me how you make this? I used the same page in other processes and it always worked perfectly.
I have already done some processes (including all the official tutorials that are in that pdf of 200 pages that I don't remember the name), but today I faced a problem that never happened to me and I couldn't fix it:
I need to paste the information that is in a data item into a cell of a .xlsm Excel file. So, I made a page in the process with the following steps:
1) Create instance
2) Open workbook
3) Show the workbook
4) Check if the worksheet were I want to paste the information exists
5) Activate worksheet
6) Use the Set Cell Value from the MS Excel VBO
7) Save the workbook
8) Close the workbook (saving it again)
9) Close all instances
I already checked that the file is macro-enabled.
When I run it step by step (i.e, pressing F10 on each action), it works perfectly. But when I run the page in just one F10 hit (remember that it's in a page, so I run the page completely with a F10 from the main page), it writes the value in the cell but then, when I open the workbook, the value is not posted. So, I suppose that the Save workbook is not working. But when I run it step by step it works perfectly! It has no sense for me, and I don't know what to do.
Can anyone tell me how you make this? I used the same page in other processes and it always worked perfectly.