Can I alter Excel to have Access switchboard style?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #166527

Can I alter Excel to have Access switchboard style?

qa-featured

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

 

Login/Register to Answer

Related Questions