QARun Writing to Excel
Can I write out to excel without dropping leading or trailing zero's on numbers? I can write to .csv and open with excel but the zero's drop. I can write to excel but it doesn't format right without manualy opening the file and doing a 'Text to columns'. I know I can put a ' in front and behind the numbers, write to .csv, and open in excel and nothing drops but then I have a ' in front and behind each number. The client doesn't want this, they want it to look and act as a true excel file. I am calling an ASP to automatically send results so I don't want manually touch anything.
This is driving me crazy.
Thanks for your help.
Re: QARun Writing to Excel
If you look at DDEPoke under DDE Commands in the language help you will find an example showing how to write data directly to an Excel spreadsheet.