late binding when vb.net 2005 updates excel 2003

[douglas]

I need to put char(5) into 'selected' columns in an excel 2003 worksheet
using vb.net 2005.
The problem is some of the data looks like '00123' and ends in the
spreadsheet looking like '123'. I am losing the leading zeroes. The only way
I know to make the selected range of columns is to make the selected columns
a 'text' format.
Basically I need to accomplish this task with late binding. (Early binding
and late binding do not mix well.) I am using late binding since I am using
the pageset feature in excel 2003.

Thus can you tell me how to solve this problem?

 

[Cor Ligthert[MVP]]

Douglas,

Why do early binding and late binding not mix well?

I've never heard of that.

But beside a piece of code this is probably all we can tell you.

(In Excel something like 00123 is as well a "text". The name in all Net
languages is "string" for that and the most simply format to create)

Cor

 

[Andrew Morton]

I need to put char(5) into 'selected' columns in an excel 2003
worksheet using vb.net 2005.
The problem is some of the data looks like '00123' and ends in the
spreadsheet looking like '123'. I am losing the leading zeroes.

Try making the data
="00123"

(including the equals sign and double quotes) so that Excel understands
you're giving it a string.

Andrew