View Single Post
  #2  
Old May 9th, 2010, 09:32 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Open Excel file with command button?

FollowHyperlink should open whatever application is associated with the file
extension. I'm guessing that if you double-click on the file in Windows
Explorer, Excel 97 opens as well. If that's the case, your options would
seem to be change the file association, or else use Automation to open an
instance of Excel 2003 and then load the workbook into that instance.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Steve Goodrich" wrote in message
...
We have two versions of MS Office installed in our office Ė 97 & 2003
We use Access 97 and Excel, Word and PowerPoint 2003
The file types are associated with the correct programs, so double
clicking
an Excel file for example will open it using Excel 2003.

I have an Access 97 db with a command button on the form that when clicked
opens an Excel file using the FollowHyperlink code.E.g. followhyperlink ď
\\servername\shared\PUBLIC\filename.xlsĒ

I have also tried to enter the hyperlink on the format tab on the property
sheet
On both occasions the file opens with Excel 97
Is there a method that I can use that will open the file in Excel 2003
All other files/shortcuts open with 2003 when double clicked

I tried to get Office 97 uninstalled except for Access 97 but we need
photo
editor 97 and was informed by our tech guy that they canít remove
word,excel & PowerPoint 97 and leave photo editor on because of the way
our
company has it packaged. Itís all done remotely and they canít do custom
installs/uninstalls.

All I want to do is open an Excel file using the 2003 version from a
command button on my form.

Any help would be appreciated

Steve



Ads