How do I add an Excel Form (not a Worksheet) to be usable in a Access dbase Form. I have a Excel Form that peoples fill out and is very code driven. But I need people to access this form from a dbase they all have on there desktop. Can a excel form be usable within an access form?
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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How Do You Add A ExcelForm to AccessForm
- Thread starter deadhead7
- Start date
FancyPrairie
Programmer
No, I don't believe you can. But, what you can do is to create a form and insert the ActiveX control "Microsoft Web Browser" on the form and then run the Excel form thru the browser.
The code to launch Excel via the Web Browser would be something like (assuming ocxWeb is the name of the ActiveX control):
Me.ocxWeb.Navigate "\\path..."
NOTE: I have not tryed this with Excel (but have read where it works nicely). I have tryed it with other packages. Has some great possibilities.
The code to launch Excel via the Web Browser would be something like (assuming ocxWeb is the name of the ActiveX control):
Me.ocxWeb.Navigate "\\path..."
NOTE: I have not tryed this with Excel (but have read where it works nicely). I have tryed it with other packages. Has some great possibilities.
- Status
Similar threads