Creating a Macro on a form to open a particular spreadsheet

[Jaharul]

Hi Everyone

What I want to do is create a button on a form in MS Access to open a particular spreadsheet in MS Excel. Please can someone help me with the actual macro or help with building such a button. I need help urgently please.

 

[bat17]

Easiest way is probably just to create a button and add a hyperlink to the button

Otherwise check out this thread on the Shell command


http://www.mrexcel.com/board2/viewtopic.php?t=90758&highlight=shell


Peter

edited to add the link I forgot