DDE Problem

That_bloke · Post by **That_bloke** » Tue Jan 23, 2007 12:10 pm

Hi there

Hope someone can help - i'm very new to this. I've written a macro to read data from a PC3270 session and output it to Excel using DDE.

Problem: Certain field values on the PC3270 session such as '5E211' appear in Excel as 5.00E+211

Does anyone know whether there is a way to force Excel to accept the data as text rather than assuming it should be Scientific format ? I tried putting an apostrophe in front of the data before doing DDEPOKE but this results in Excel displaying an apostrophe in front of the text.

Would much appreciate any ideas.

JRL · Post by **JRL** » Fri Jan 26, 2007 10:12 pm

This is an Excel problem. Microsoft support article 214233 discusses this issue and its possible resolutions. I'm going to make a prediction that you won't like any of them. You've already tried and rejected one of their suggestions.

That_bloke · Post by **That_bloke** » Mon Jan 29, 2007 12:49 pm

Thanks for the info.... you're right, I didn't particularly care for their solutions but it did give food for thought and I have now managed to get it to work by wrapping the field with the =CONCATENATE function before sending it to Excel

Thanks again