Stopping Excel from changing data through OLE
Stopping Excel from changing data through OLE
(OP)
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???
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???
RE: Stopping Excel from changing data through OLE
RE: Stopping Excel from changing data through OLE
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
RE: Stopping Excel from changing data through OLE
lu
RE: Stopping Excel from changing data through OLE
Thanks mate, I'll give it a go.