Hi there,

I am writing a VB.NET application, which gets certain data from a spreadsheet.

Currently, the user has to edit the spreadsheet outside the application.

Is there a way that I can load the spreadsheet into a window of my application, so the user can edit it there? If so, can he still link certain cells to data contained in other external spreadsheets/data-sources, using the same method he'd use if the spreadsheet was stand-alone?

Hope you can help.

Thanks.

James

//##

You can use the System.Data and System.Data.OLEDB objects to access an excel spreadsheet, which should allow you to do updates through a control such as a DataGrid. You should be able to update in that manner.

Hope this helps,

Brian

Thanks, Brian.

Thinking further... what I really need is not a "spreadsheet within my application", but simply a DataGrid.

However, a spreadsheet can have cells that pick up data from external sources (the particular source I am interested in is a data feed from Bloomberg).

My DataGrid would need to do the same. So the question really is - how do I link to Bloomberg from my VB application?

For distributed applications, you can use .NET remoting or XML Web services. Are you saying that you need to connect to a data source in Bloomberg which has the Excel files, or that the Excel spreadsheets connects to the data source?