M
MDW
Is there a way for me to set up a "window" in a form into which I can load
(and, ideally, un-load) pre-existing Excel workbooks? Essentially, I'm going
to use the FileSystemObject to read all the files available in a given
folder, and the users will pick from a list box.
I want to display the workbook just as though it appears if you open it in
Excel (or conversely, how it would be displayed in MSIE if you opened a
spreadsheet on the Web). The users do not need to actually make changes to
the contents; I just want them to view the info that's on the sheets.
I'm using Access 2003. I tried creating an "MS Office Spreadsheet" control
to the form, but I don't see a property or method that would allow me to load
a saved workbook.
TIA.
(and, ideally, un-load) pre-existing Excel workbooks? Essentially, I'm going
to use the FileSystemObject to read all the files available in a given
folder, and the users will pick from a list box.
I want to display the workbook just as though it appears if you open it in
Excel (or conversely, how it would be displayed in MSIE if you opened a
spreadsheet on the Web). The users do not need to actually make changes to
the contents; I just want them to view the info that's on the sheets.
I'm using Access 2003. I tried creating an "MS Office Spreadsheet" control
to the form, but I don't see a property or method that would allow me to load
a saved workbook.
TIA.