Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Embedding Excel into an Access form

Status
Not open for further replies.
3576

3576

Programmer
Jan 28, 2005
32
US
I need to embed an Excel into an MS Access form and link the excel form to a query or a table. Any suggestions are appreciated.

Thanks,

TW
 
Sort by date Sort by votes
You might try inserting the ActiveX control "Microsoft Web Browser" on your form. In the OnOpen event of your form navigate to the excel form. For example, assume that the web browser control is named oWeb, then the OnOpen event would look something like this:

oWeb.Navigate "\\path\YourExcelFile"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
785
dhookom
dhookom
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
448
Xavierparkash
Xavierparkash
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
607
TrekBiker
TrekBiker
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
544
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top