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.Â
Thank you.
Hi Artman,
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.
Sub Excel()
        Dim ExApp As Variant
        DoCmd.RunCommand acCmdAppMinimize
        Set ExApp = CreateObject("Excel.Application")
   ExApp.Workbooks.Open FileName:="C:UsersXXXXXDesktopForms Lookup 1.0.0.2.xlsm"
   ExApp.Visible = True
   Sheets("Individual Form Lookup").Select     Â
End Sub
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.
Thanks
Â
