Stopping Excel from changing data through OLE

hojo · Dec 12, 2002

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 · Dec 13, 2002

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

hojo · Dec 15, 2002

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 · Jun 23, 2003

just ad ' as first character of the string

lu

hojo · Jun 23, 2003

Of course. The simplest solution is always the best.

Thanks mate, I'll give it a go.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Stopping Excel from changing data through OLE

hojo

Computer

cowski

Mechanical

hojo

Computer

lucsax

Civil/Environmental

hojo

Computer

Similar threads

Part and Inventory Search

Sponsor