need help with opening excel automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Thanks so much! that worked!!



Klatuu said:
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.
Click to expand...
 
Glad to help.
Please rate the post so others search for a similar answer can identify it
as an answered question.
 
Back
Top