The Worksheet already exists?
Open the form in Design View.
Click on Insert + Object + Microsoft Excel Worksheet.
Click on Create From File. Navigate to the spreadsheet.
Click OK.
Place a check in the Link check box.
Click OK
After the worksheet is added to the form, make sure the OLEUnbound
Control's Locked property is set to No and it's Enabled property is
set to Yes.
Only the first sheet will be displayed.
Double-click on the worksheet to edit it.
When you're in edit mode you can access all the worksheets.
fredg's answer will get you where you want to go; however, in my experience,
using an OLE bound control to present an excel sheet on an Access form is
very slow. It is slow to load and slow to save.
If you have the same issue, you may consider just using the Shell statement
to open Excel with the spreadsheet.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
