Write Cell not able to pass correct value and save it

Help StudioX
1

Hello guys, I hope anyone can help me with this.

I need to get data from a cell in my Excel file, input that data into a website, get the result from the website, and then write that result back into a cell in the same Excel file.

I’m using check app state to facilitate the 2 different results. One result is a discount amount and the other is a text saying that there’s no discount which means to pass value 0.

I have 3 excel files, the first and the 3rd file are expected to get discount amounts and upon running the results are correct. However, for my 2nd file, the write cell doesn’t seem to get the correct data and not able to save the file right after. I have setup a message box to check the runtime value, the message says “-” and upon clicking OK, I can see that the value on that cell changes back to the original amount.

It’s weird because if I try to make the 2nd file the first one to be processed which I expect to get 0 amount since the result from the website is no discount for that one, it proceeds successfully.

I really appreciate any thoughts/help from you guys. Thank you in advance!

2

@keevcodata

Welcome to the community

Can you show a screenshot please

Also try to recreate the file and check

Cheers

1 Like