G
Guest
Is it possible to use an Access form to view specific ranges from linked
Excel spreadsheets in a read-only or print preview format?
My goal is to use a tab control on an Access form to select from an
assortment of Excel sheets, and to allow the user to scroll through and
possibly print the selected sheet, but not to open it in Excel.
I was hoping this would be possible by manipulating OLE objects with vba,
but I have had little luck getting a specified range to appear in an OLE
object frame, (the sheet is often cropped at an atbitrary row/column, and I
cannot figure out how to control which range or sheet is displayed from the
source workbook).
I have no experience with OLE, and presuming that my ignorance is the
problem, can someone please point me to a good resource for picking up the
basics of coding with OLE objects?
Otherwise, is there a better approach to accomplish this? ANy suggestions
greatly appreciated.
TIA
T Kirtley
Excel spreadsheets in a read-only or print preview format?
My goal is to use a tab control on an Access form to select from an
assortment of Excel sheets, and to allow the user to scroll through and
possibly print the selected sheet, but not to open it in Excel.
I was hoping this would be possible by manipulating OLE objects with vba,
but I have had little luck getting a specified range to appear in an OLE
object frame, (the sheet is often cropped at an atbitrary row/column, and I
cannot figure out how to control which range or sheet is displayed from the
source workbook).
I have no experience with OLE, and presuming that my ignorance is the
problem, can someone please point me to a good resource for picking up the
basics of coding with OLE objects?
Otherwise, is there a better approach to accomplish this? ANy suggestions
greatly appreciated.
TIA
T Kirtley