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
Printable View
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
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.Quote:
Originally Posted by TCarter
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.Quote:
Originally Posted by MacShand
not selling it im afraid...building it for our school radio station..not for profit...
For fun http://www.codeproject.com/KB/office...ing_Excel.aspx which needs converting to VB from C Sharp.
See my second reply, it will be a good deal of effort on your part.Quote:
Originally Posted by 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!!
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