Prev: further help deploying an application within my database
Next: Updating Data in Multiple Tables
From: Steve Goodrich on 9 May 2010 14:29 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
From: Douglas J. Steele on 9 May 2010 16:32 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" <stevegoodrich(a)btinternet.com> wrote in message news:daDFn.536017$gF5.247933(a)en-nntp-01.am2.easynews.com... > 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 >
From: Steve Goodrich on 9 May 2010 16:48 Doug, Thanks for your reply. I have set my file associations so that Excel opens in 2003. Every Excel file I click in windows explorer does open in 2003. It's when I use a command button to open the file that it opens in 97. How do I use automation to load Excel 2003 and then load the workbook? Steve. "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message news:Oks%235a77KHA.1424(a)TK2MSFTNGP04.phx.gbl... > 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" <stevegoodrich(a)btinternet.com> wrote in message > news:daDFn.536017$gF5.247933(a)en-nntp-01.am2.easynews.com... >> 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 >> > >
From: Douglas J. Steele on 9 May 2010 17:35 Hmm. That's odd. I thought FollowHyperlink respected the file associations. One other thing to try before going to the trouble of using Automation. Try the ShellExecute API, as illustrated in http://www.mvps.org/access/api/api0018.htm at "The Access Web" -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/djsteele (no e-mails, please!) "Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message news:ZcFFn.31888$sp1.22634(a)en-nntp-04.am2.easynews.com... > Doug, > Thanks for your reply. > I have set my file associations so that Excel opens in 2003. Every Excel > file I click in windows explorer does open in 2003. It's when I use a > command button to open the file that it opens in 97. > > How do I use automation to load Excel 2003 and then load the workbook? > > Steve. > > "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message > news:Oks%235a77KHA.1424(a)TK2MSFTNGP04.phx.gbl... >> 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" <stevegoodrich(a)btinternet.com> wrote in message >> news:daDFn.536017$gF5.247933(a)en-nntp-01.am2.easynews.com... >>> 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 >>> >> >> > >
From: Steve Goodrich on 11 May 2010 08:31 Thanks Douglas for the advice but I'm afraid the solution is far above my skill level at the moment Steve "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message news:O9peJ%2377KHA.5464(a)TK2MSFTNGP05.phx.gbl... > Hmm. That's odd. I thought FollowHyperlink respected the file > associations. > > One other thing to try before going to the trouble of using Automation. > Try the ShellExecute API, as illustrated in > http://www.mvps.org/access/api/api0018.htm at "The Access Web" > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/djsteele > (no e-mails, please!) > > > > "Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message > news:ZcFFn.31888$sp1.22634(a)en-nntp-04.am2.easynews.com... >> Doug, >> Thanks for your reply. >> I have set my file associations so that Excel opens in 2003. Every Excel >> file I click in windows explorer does open in 2003. It's when I use a >> command button to open the file that it opens in 97. >> >> How do I use automation to load Excel 2003 and then load the workbook? >> >> Steve. >> >> "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message >> news:Oks%235a77KHA.1424(a)TK2MSFTNGP04.phx.gbl... >>> 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" <stevegoodrich(a)btinternet.com> wrote in message >>> news:daDFn.536017$gF5.247933(a)en-nntp-01.am2.easynews.com... >>>> 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 >>>> >>> >>> >> >> >
|
Next
|
Last
Pages: 1 2 Prev: further help deploying an application within my database Next: Updating Data in Multiple Tables |