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!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stopping Excel from changing data through OLE

Status
Not open for further replies.

hojo

Computer
Joined
Oct 9, 2002
Messages
18
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???
 
You might try converting those numbers to strings before sending them to Excel.
 
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
 
just ad ' as first character of the string

lu
 
Of course. The simplest solution is always the best.

Thanks mate, I'll give it a go.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top