embed excel

[MacShand]

Hi!

Just wondering if its possible to embed an excel spreadsheet in my form and maintain its functionality - so i can edit it, formula still works etc etc...

and also if changes are made, save the spreadsheet and so on.

thanks in advance!

m

[TCarter]

http://support.microsoft.com/kb/242243

[kareninstructor]

http://support.microsoft.com/kb/242243

This is VB6 style of coding and would highly suggest not using it as it uses late binding and VB6 method of exception handling. Bottom line, just because it might work does not mean you should use it.

[MacShand]

ok, thanks for both...Im using VB 2010...what's the best way to proceed?

[kareninstructor]

ok, thanks for both...Im using VB 2010...what's the best way to proceed?

If you are building an app that you are selling then Aspose Cells.

[MacShand]

not selling it im afraid...building it for our school radio station..not for profit...

[kareninstructor]

For fun http://www.codeproject.com/KB/office...ing_Excel.aspx which needs converting to VB from C Sharp.

[kareninstructor]

not selling it im afraid...building it for our school radio station..not for profit...

See my second reply, it will be a good deal of effort on your part.

[MacShand]

thank you, i dont think im experienced enough to know what to do to convert it :S been googling for ages to try to find a solution and not really getting anywhere... thought itd be easier!!

[Grimfort]

Maybe you should do something simpler, such as launching excel and opening the required workbook. Then you can monitor the file itself and know when a user has saved the file and do something with it, if required. Programming is not just about grabbing existing systems and throwing them into your app and it works in 15 mins , it takes days to get something decent together and often if you want something specific, you end up buying a 3rd party control which can do what you want. ie SpreadSheetGear