Can I alter Excel to have Access switchboard style?

Asked By artman gillon 0 points N/A Posted 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. 

Thank you.

• Status: Open
• Question Views: 1025
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Lynda M Harvey 0 points N/A #166527

Can I alter Excel to have Access switchboard style?

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

 

About Lynda M Harvey

Questions
7

Answers
66

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 03/17/2013
• Question Category: MS Access