Newbie needs help

[jspear]

Using VS 2003, I need to access Excel workbooks and sheets. anyone have some code snippets to do this? All help/advice gratefully appreciated
Jim

[Ole Raptor]

Is there anything special you need to do with these once you have located the files?

[debasisdas]

What exactly youa re trying to do.

[jspear]

Thanks for your reply. I need to let anyone view the worksheets with no way to change them and another group to be able to modify them. I don't know whether , or how, to do this with code or on the spreadsheet itself. Again, I really appreciate you taking the time to help me.
Regards, Jim

[GL.Za]

Just to clarify, do you want to open excel through your application or just display the data on a form?

[jspear]

Thanks for your response. I think That just opening Excel through the application will handle what I need to do. Again thanks for your help.

Jim

[GL.Za]

Sorry about the delay, but here is a link to a page with some good code.

http://xldennis.wordpress.com/2007/11/16/open-excel-workbooks-in-vbnet-solutions/

It gives three different options, so one of them should work for you. I used none of them cos i just used a datagridview & dataset - but its simialr to the spreadsheet component option given.

Hope this helps.