need help with opening excel automatically

[Guest]

i have a command button that transfer an access form to a specific excel
file, and i'd like to have it so that once that button's clicked, the data is
transferred, and that excel file where it was saved, would pop up....

I've done a search here, and i've seen answers relating to hyperlinks, shell
codes....and most of these answers are like Greek to me (can you tell i'm a
beginner??!!)

Can someone please help me using plain and simple english how to accomplish
my task? thanks in advance!

 

[Guest]

To make it simple, you can use a Macro.
To export the data to Excel, use the Transferspreadsheet Action.
To open the spreadsheet in Excel, use the RunApp Action.
You can look up the details in Help on these two actions.

 

[Guest]

Thanks so much! that worked!!

To make it simple, you can use a Macro.
To export the data to Excel, use the Transferspreadsheet Action.
To open the spreadsheet in Excel, use the RunApp Action.
You can look up the details in Help on these two actions.

 

[Guest]

Glad to help.
Please rate the post so others search for a similar answer can identify it
as an answered question.