If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help with opening excel automatically
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! |
#2
|
|||
|
|||
need help with opening excel automatically
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. "lay" wrote: 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! |
#3
|
|||
|
|||
need help with opening excel automatically
Thanks so much! that worked!!
"Klatuu" wrote: 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. "lay" wrote: 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! |
#4
|
|||
|
|||
need help with opening excel automatically
Glad to help.
Please rate the post so others search for a similar answer can identify it as an answered question. "lay" wrote: Thanks so much! that worked!! "Klatuu" wrote: 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. "lay" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|