Good morning !
I am using WIN XP SP2 and Office 2007.
In VBA, I want to show a particular item of Excel help, for example the item
relative to the help method.
A right click on the window of the help file, open on the method
"Application.help" gives the opportunity to copy the reference of the item :
HV10035867 . The command "display the source" brings up a message box "The
XML file cannot be seen". If I use in a sub
Application.Help , HV10035867 nothing happens. If I use Application.Help ,
10035867 the help file is opened but only on the first page.
What is the right syntax to get a particular item ?
Thanks
Aeronav

There are a few changes in 2007

I update the functions workbook on my site
http://www.rondebruin.nl/id.htm

But not looked at the other items

In 2007 you use

Application.Assistance.ShowHelp



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aeronav" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Good morning !
> I am using WIN XP SP2 and Office 2007.
> In VBA, I want to show a particular item of Excel help, for example the item
> relative to the help method.
> A right click on the window of the help file, open on the method
> "Application.help" gives the opportunity to copy the reference of the item :
> HV10035867 . The command "display the source" brings up a message box "The
> XML file cannot be seen". If I use in a sub
> Application.Help , HV10035867 nothing happens. If I use Application.Help ,
> 10035867 the help file is opened but only on the first page.
> What is the right syntax to get a particular item ?
> Thanks
> Aeronav
>
>

Thanks for your reply, it works now if I write
"Aplication.Assistance.ShowHelp "HV10093546", "DEV"

>"Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news:
>%(E-Mail Removed)...
> There are a few changes in 2007
>
> I update the functions workbook on my site
> http://www.rondebruin.nl/id.htm
>
> But not looked at the other items
>
> In 2007 you use
>
> Application.Assistance.ShowHelp
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm

I update the page today
http://www.rondebruin.nl/id.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aeronav" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Thanks for your reply, it works now if I write "Aplication.Assistance.ShowHelp "HV10093546", "DEV"
>
>>"Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news: %(E-Mail Removed)...
>> There are a few changes in 2007
>>
>> I update the functions workbook on my site
>> http://www.rondebruin.nl/id.htm
>>
>> But not looked at the other items
>>
>> In 2007 you use
>>
>> Application.Assistance.ShowHelp
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>
>

Bonjour,
I am always obliged to use the second argument "DEV", like
Application.Assistance.ShowHelp "HV10072384", "DEV" to go to a particular
topic,. If I use "" instead of "DEV" I go to the first page of the help
file.
But it is OK for me. Salutations
Aeronav

"Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news:
uZ4365$(E-Mail Removed)...
>I update the page today
> http://www.rondebruin.nl/id.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Aeronav" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Thanks for your reply, it works now if I write
>> "Aplication.Assistance.ShowHelp "HV10093546", "DEV"
>>
>>>"Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news:
>>>%(E-Mail Removed)...
>>> There are a few changes in 2007
>>>
>>> I update the functions workbook on my site
>>> http://www.rondebruin.nl/id.htm
>>>
>>> But not looked at the other items
>>>
>>> In 2007 you use
>>>
>>> Application.Assistance.ShowHelp
>>>
>>>
>>> --
>>>
>>> Regards Ron de Bruin
>>> http://www.rondebruin.nl/tips.htm
>>
>>
>

Hi Aeronav

I will add a note about the second argument on the page to make it complete.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aeronav" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Bonjour,
> I am always obliged to use the second argument "DEV", like Application.Assistance.ShowHelp "HV10072384", "DEV" to go to a
> particular topic,. If I use "" instead of "DEV" I go to the first page of the help file.
> But it is OK for me. Salutations
> Aeronav
>
> "Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news: uZ4365$(E-Mail Removed)...
>>I update the page today
>> http://www.rondebruin.nl/id.htm
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "Aeronav" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>>> Thanks for your reply, it works now if I write "Aplication.Assistance.ShowHelp "HV10093546", "DEV"
>>>
>>>>"Ron de Bruin" <(E-Mail Removed)> a écrit dans le message de news: %(E-Mail Removed)...
>>>> There are a few changes in 2007
>>>>
>>>> I update the functions workbook on my site
>>>> http://www.rondebruin.nl/id.htm
>>>>
>>>> But not looked at the other items
>>>>
>>>> In 2007 you use
>>>>
>>>> Application.Assistance.ShowHelp
>>>>
>>>>
>>>> --
>>>>
>>>> Regards Ron de Bruin
>>>> http://www.rondebruin.nl/tips.htm
>>>
>>>
>>
>
>