Linking to specific Excel spreadsheet from Access form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Decembersonata - 01 Feb 2006 15:51 GMT

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

Reply to this Message

fredg - 01 Feb 2006 18:09 GMT

> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

John Nurick - 01 Feb 2006 19:16 GMT

If Fred's response isn't what you were thinking of, how about
DoCmd.TransferSpreadsheet acLink... ?

>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.

Reply to this Message