Using Send Keys to move data from Excel to Notepad and save as CSV
Hi All,
I am currently working on a macro which brings data in from an external worksheet, manipulates it and saves it as a CSV. One of the problems I encountered was that some of the text was in Thai language characters and this showed up as question marks in the CSV output. I managed to find a way around this through using SendKeys to open notepad, paste data and save as, however when it got to the save as window I was required to manually:
Bookmarks