Open Excel spreadsheet from access form

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

How can I open a specfic Excel workboork/worksheet from
inside of access?

I'd like to add a button cotrol to a form to open an
Excel spreadsheet which is on another computer on a
network.

Thanks in advance.
..
 
Hi Stephen,

The simplest way is usually to use

Application.FollowHyperlink strPath

where strPath is a string variable containing the UNC path
(\\COMPUTER\Share\Folder\File.xls) or - if the shared folder on the
other computer is mapped to a drive letter on your computer - the
Windows path (D:\Folder\File.xls).

For more control, use Automation:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235



Also, search www.mvps.org/access
 
Back
Top