Hi,

im trying to work out a way of exporting a range of data from an excel worksheet to a flat text file.

My original procedure was to create the data required by the file, use shell to open notepad, then use various send key commands to paste the data in to the new notepad file.. I then used send keys to save and clsoe the text file. worked fine on my PC, but on a colleagues, the send keys commands didnt want to know for some reason. Same PC's, same operating system, same office versions and as far as I can see they were configured correctly.

I tohught that maybe a redesign could be my answer, instead of copying from excel to notepad, maybe I could save the spreadsheet directly to the text file I need. ive been through the various txt saving options under "save as" but all wrap my save data with " " . These will mess up the import of the file in to my target system.

Does anyone know of a good way of exporting this data without the quotes, or why my original file worked on one PC but not the other?

I need to export my data as comma seperated, but with the txt suffix (rather than csv).

any ideas welcome!!