Stopping Excel from changing data through OLE

[hojo]

Hi All

I have a Visual basic program i've developed to control the stock levels at work.

To print out reports in a logical set out i've sent the data from a MSFlexGrid(which i use to display on screen) to Excel so as it will print in columns.

This works fine but excel in all its genius changes some ID numbers like "4-8093" to a date like "Apr-93".

Can Anyone help???

 

[cowski]

You might try converting those numbers to strings before sending them to Excel.

 

[hojo]

Thanks for the try but Excel still sees the data in date format.

I've noticed that the Excel OLE object has a "rejectallchanges" method. Pehaps this my be helpful if i knew its parameters. Its askes for [when,who,where].

Isn't problem solving fun.

tar

 

[lucsax]

just ad ' as first character of the string

lu

 

[hojo]

Of course. The simplest solution is always the best.

Thanks mate, I'll give it a go.