Re: [MS_AccessPros] Code to open Excel workbook in Access

 

Hi John,

The code below does not work. What's wrong?

Option Compare Database

Sub OpenExcel()
Application.FollowHyperlink ("C:\Documents\ProjectToAccess\SMTHTAToExcel.xlsx")
End Sub

On Mon, Dec 14, 2015 at 12:00 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

James-

The simplest way is to use the FollowHyperlink method in VBA:

    Application.FollowHyperlink "C:\My Documents\MySpreadsheet.xlsx"

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Dec 14, 2015, at 10:58 AM, James Asante asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi,

I want to be able to click a button on a form to open an Excel workbook (export.xlsx) sitting in the Documents folder of my pc.

Please help with a macro or vb.

Regards,

James Asante

__._,_.___

---

Posted by: James Asante <asanteza@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___