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
|
|||
|
|||
Linking to specific Excel spreadsheet from Access form
My access db relies on information that first must be reformatted using
Excel. On my Add New Record form, I want to link to this Excel spreadsheet using a command button. How do I specifiy the specific spreadsheet to be called up? I'm assuming I'll use an On Click procedure, but need help writing the Visual basic code. Thanks |
#2
|
|||
|
|||
Linking to specific Excel spreadsheet from Access form
On Wed, 1 Feb 2006 07:51:27 -0800, Decembersonata wrote:
My access db relies on information that first must be reformatted using Excel. On my Add New Record form, I want to link to this Excel spreadsheet using a command button. How do I specifiy the specific spreadsheet to be called up? I'm assuming I'll use an On Click procedure, but need help writing the Visual basic code. Thanks If you wish to open the specific spreadsheet using a command button, you can use: Application.Followhyperlink "Path to spreadsheet\SpreadsheetName.xls" You could also link to the spreadsheet using an OLEUnbound control. If you set it's Enabled property to Yes, and it's Locked property to No, clicking on the control will open the spreadsheet. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Linking to specific Excel spreadsheet from Access form
If Fred's response isn't what you were thinking of, how about
DoCmd.TransferSpreadsheet acLink... ? On Wed, 1 Feb 2006 07:51:27 -0800, "Decembersonata" wrote: My access db relies on information that first must be reformatted using Excel. On my Add New Record form, I want to link to this Excel spreadsheet using a command button. How do I specifiy the specific spreadsheet to be called up? I'm assuming I'll use an On Click procedure, but need help writing the Visual basic code. Thanks -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Large Access Table into Excel | Steven M. Britton | Links and Linking | 1 | December 30th, 2005 11:28 PM |
Error importing Excel spreadsheet into an existing Access table. | StargateFanFromWork | New Users | 6 | December 15th, 2005 06:16 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Single Excel Cell to Access Form | Robert Blair via AccessMonster.com | Using Forms | 3 | April 17th, 2005 03:32 PM |