RE: [MS_AccessPros] Display Excel sheet on Access form

 

Hi <your name?>

 

You can embed an excel sheet using an OLE control that is linked to the spreadsheet. It's not the usual way to display a spreadsheet. You might want to just put a button with an event to follow a hyperlink to the sheet on the form to open the spreadsheet outside of Access.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, March 08, 2018 12:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Display Excel sheet on Access form

 

 

I need to display Excel sheet with one table and one chart on Access form. Is it possible to have preview of excel sheet on access form which will automatically update when excel sheet is update?

__._,_.___

---

Posted by: "Bill Mosca" <wrmosca@comcast.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___