Prev: Help with USB & DEVICEARRIVAL
Next: Move/Click Mouse Programmatically in WebBrowser control
From: BlackSun on 16 Sep 2009 08:59
Hi,
I have a problem when I copy values from cells of Excel and insert
them into a DataGridView.
In Excel I have a cell with a custom format ("ddd"), in the cell
there's the date but I see "sun" (cell formatted with "ddd"
How can I copy "sun" in the DataGridView and not the date??

Thanks in advance!

Cheers BlackSun
From: OmegaSquared on 16 Sep 2009 17:07
Hello, BlackSun,

If you use the cell's Value property (instead of its Text property) I think
you will get what you need.

Cheers,
Randy

From: BlackSun on 17 Sep 2009 04:19
Hi,
Thank you for your reply.
You gave me a good way to resolve it.
It works in this way:

Grid.Item(1, 1).Value = CType(mySheet.Cells(15,29), Excel.Range).Text

In the wrong version I used CType(mySheet.Cells(15,29),
Excel.Range).Value

Thank you very much!

Bye BlackSun


On 16 Set, 23:07, OmegaSquared
<OmegaSqua...(a)discussions.microsoft.com> wrote:
> Hello, BlackSun,
>
> If you use the cell's Value property (instead of its Text property) I think
> you will get what you need.
>
> Cheers,
> Randy

From: OmegaSquared on 17 Sep 2009 14:17
Hello, BlackSun,

Yes, sorry about that. I read your original post too quickly and thought
you wanted to get the date back instead of the day. I'm glad you were able
to sort it out despite that confusion.

Cheers,
Randy

From: BlackSun on 18 Sep 2009 04:11
Hi,
don't worry about that... it's ok :-)
You gave me the idea :-)

Cheers,
BlackSun


On 17 Set, 20:17, OmegaSquared
<OmegaSqua...(a)discussions.microsoft.com> wrote:
> Hello, BlackSun,
>
> Yes, sorry about that.  I read your original post too quickly and thought
> you wanted to get the date back instead of the day.  I'm glad you were able
> to sort it out despite that confusion.
>
> Cheers,
> Randy

 | 
Pages: 1
Prev: Help with USB & DEVICEARRIVAL
Next: Move/Click Mouse Programmatically in WebBrowser control