1.

Solve : Excel help with updating data?

Answer»

Hello,

I encountered the problem with excel asking whether i want to update the daa or not. COULD you help me with the following?

After opening excel file, could you write a command that would update the DATA (press the enter button that the file will open with data updated)? (adjusting excel options that it will update AUTOMATICALLY is not an option)

After doing that, I want to save fale as "current file name date"

I am pretty NEW with this and i tried googling, it didnt helped.

Thanks for help!Is it asking if you want to update links?Yes, i solved the problem by porbably not the most efficient way. I WROTE a command to sendkey "U", and then it updates. If you have more sophisticated method to do so, you are more than welcome to help. Also, i havent figured out the commands how to save file with current date in it.



Discussion

No Comment Found