If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open Excel file with command button?
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 |
Thread Tools | |
Display Modes | |
|
|