Prev: further help deploying an application within my database
Next: Updating Data in Multiple Tables
From: Douglas J. Steele on 11 May 2010 10:34
Actually, using that approach is far simpler than Automation would be!

Go into the VB Editor and create a new module (not a class module nor a
module associated with a form or report)

Copy everything between Code Start and Code End on the web page, and paste
it into the new module.

Save the module, giving it a unique name (something like mdlShellExecute
should work fine)

In your Click event, use

Call fHandleFile("\\servername\shared\PUBLIC\filename.xls")

instead of the FollowHyperlink method.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message
news:q6cGn.536437$gF5.373369(a)en-nntp-01.am2.easynews.com...
> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>
>


From: Steve Goodrich on 11 May 2010 17:41
Thanks, I'll give it a try when I get back to the office
Steve
"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message
news:uwg0dcR8KHA.1888(a)TK2MSFTNGP05.phx.gbl...
> Actually, using that approach is far simpler than Automation would be!
>
> Go into the VB Editor and create a new module (not a class module nor a
> module associated with a form or report)
>
> Copy everything between Code Start and Code End on the web page, and paste
> it into the new module.
>
> Save the module, giving it a unique name (something like mdlShellExecute
> should work fine)
>
> In your Click event, use
>
> Call fHandleFile("\\servername\shared\PUBLIC\filename.xls")
>
> instead of the FollowHyperlink method.
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message
> news:q6cGn.536437$gF5.373369(a)en-nntp-01.am2.easynews.com...
>> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
>


From: Steve Goodrich on 13 May 2010 12:01
Hi
Finally got it working with:

Shell """C:\Program Files\Microsoft Office\office11\excel.exe""
""\\server\shared\public\folder\file.xls""", vbMaximizedFocus

Thanks for all your help

Steve

"Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message
news:oakGn.69865$YL2.42678(a)en-nntp-06.am2.easynews.com...
> Thanks, I'll give it a try when I get back to the office
> Steve
> "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message
> news:uwg0dcR8KHA.1888(a)TK2MSFTNGP05.phx.gbl...
>> Actually, using that approach is far simpler than Automation would be!
>>
>> Go into the VB Editor and create a new module (not a class module nor a
>> module associated with a form or report)
>>
>> Copy everything between Code Start and Code End on the web page, and
>> paste it into the new module.
>>
>> Save the module, giving it a unique name (something like mdlShellExecute
>> should work fine)
>>
>> In your Click event, use
>>
>> Call fHandleFile("\\servername\shared\PUBLIC\filename.xls")
>>
>> instead of the FollowHyperlink method.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://www.AccessMVP.com/DJSteele
>> (no e-mails, please!)
>>
>> "Steve Goodrich" <stevegoodrich(a)btinternet.com> wrote in message
>> news:q6cGn.536437$gF5.373369(a)en-nntp-01.am2.easynews.com...
>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>
>


From: Len on 1 Jun 2010 18:31

"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
>

First  |  Prev  | 
Pages: 1 2
Prev: further help deploying an application within my database
Next: Updating Data in Multiple Tables