ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting Spreadsheet control data source to Excel file (https://www.excelbanter.com/excel-programming/281461-setting-spreadsheet-control-data-source-excel-file.html)

Lyndsey

Setting Spreadsheet control data source to Excel file
 
I am trying to use either the Excel spreadsheet (as an
insertable object) or the spreadsheet web control to load
the contents of an Excel file. I then need to save the
changes made in the spreadsheet control back into the
file. This must include all formatting as well as text.

Can anyone help me with this? I have not been able to
find a way of setting the source of the control to an
Excel file, but surely this is possible!?


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com