Office apps

  • Thread starter Thread starter Dan Sully
  • Start date Start date
D

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.
 
Hi Dan,

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

Application.FollowHyperlink "D:\Folder\Subfolder\File.xls"
 
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
 
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.
 
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?
 
Back
Top