Click here to Skip to main content
15,892,965 members

Comments by Vijay hit (Top 16 by date)

Vijay hit 11-Jun-13 7:37am View    
Hi Rajan,

Thanks a lot. Just by changing connection string it worked well.
As you mentioned we need to add Xml to Extended property.
'Xml' should be added to make ' Extended Properties=""Excel 12.0 Xml;HDR=YES '.

Offf... I was sick of searching for the answer from 2 days. Really it helped a lot.

Thanking you once again.
Vijay hit 11-Jun-13 5:37am View    
Hi Bernhard,

Thanks for the valuable answer.
Do you mean the way I am saving file using OLEDB is old method. In that case could you please let me know
how I can save .XLSX in new format(May be piece of code).

Or you mean I might be saving in .xls format,In that case my answer is I am saving file in new format i.e .XLSX (You can now see in my question which I have modified and also mentioned the path).

I am really exhausted to find the solution for this.

Appreciate comment.
Vijay hit 21-Nov-12 22:12pm View    
Hi Sergey,

Thanks for the info.
I used GetData method suggested by you to get the clipboard content.
It is working fine.

Regards,
Vijay
Vijay hit 19-Nov-12 21:52pm View    
Hi Sergey,

Thanks for the answer.

Cursor.Current = Cursors.Default din't worked as Default is not appearing in cusors.
I am getting error like default is not a member of cursors.


But your blog helped a lot. I just used your technique of setting Previous and it worked well.

Dim previous as system.windows.input.cursor = me.cursor
me.Cursor = cursors.wait

after my task I reset the cursor by
me.cursor = previous.

Thanks again,
Vijay
Vijay hit 7-Nov-12 0:22am View    
In current situation my PM approach seems not bad. We just need to scratch a head lot.
Later it will ease our work for further design.

I have accepted your answer (sorry..Suggestions.)