Hi everyone,
So I am trying to read a row of dates but they seem to have a formula and everytime I write line to string it converts to the general format in excel (in a way). How can I go about this? Should I copy and paste as values first?
Hi everyone,
So I am trying to read a row of dates but they seem to have a formula and everytime I write line to string it converts to the general format in excel (in a way). How can I go about this? Should I copy and paste as values first?
Hi @ktanli,
Just use a vbscript by using the invoke vba activity and it will be done in seconds.
Let me know if you are not able to achieve that and want a xaml.
Cheers,
Shikhar