N/APosted on - 02/23/2013
I have Microsoft Excel 2010 and I was wondering if I could change or alter it with Access switchboard so I could access reports in my database?
I need feedback if access switchboard style for MS Excel is possible.
Can I alter Excel to have Access switchboard style?
You can alter/change Msexcel 2010 through switch board .There 2 ways of doing this:
1)First create a macro to connect excel to msaccess switchboard.
Dim ExApp As Variant
Set ExApp = CreateObject("Excel.Application")
ExApp.Workbooks.Open FileName:="C:UsersXXXXXDesktopForms Lookup 18.104.22.168.xlsm"
ExApp.Visible = True
Sheets("Individual Form Lookup").Select
2)You can download some freeware software.You can download one such software from the below link .This software uses MS Excel as a front-end interface to a MS Access database.
Use Excel to import and export tables to and from an Access database.