Office apps

[Dan Sully]

How do I open a specified Excel spreadsheet from an access (vba) program? Do
I need any special references to make this work?

Thanks for your help.

 

[John Nurick]

Hi Dan,

There are several ways of doing it, but the simplest is probably

Application.FollowHyperlink "D:\Folder\Subfolder\File.xls"

 

[Dan Sully]

It trys but seems to hang with Excel half way open but not fully displayed.
Could you give me a couple of alternatives?

Thanks again

 

[John Nurick]

If it doesn't work there's probably something wrong somewhere with your
computer's setup. When you double-click on the .xls file in a My
Computer window, does it open properly?

Another approach is to control Excel explicitly from Access via
Automation: see http://www.mvps.org/access/modules/mdl0006.htm to get
started.

 

[Dan Sully]

Yes, the spreadsheet starts normally when selected in other ways. It looks
like the video is hung because it partially displays but doesn't progress. I
have a two monitor system and I can display four or five applications at a
time without thrashing. Curious?