| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling for a particuler item of Excel 2007 help
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling for a particuler item of Excel 2007 help
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling for a particuler item of Excel 2007 help
Thanks for your reply, it works now if I write
"Aplication.Assistance.ShowHelp "HV10093546", "DEV" "Ron de Bruin" a écrit dans le message de news: ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling for a particuler item of Excel 2007 help
I update the page today
http://www.rondebruin.nl/id.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Aeronav" wrote in message ... Thanks for your reply, it works now if I write "Aplication.Assistance.ShowHelp "HV10093546", "DEV" "Ron de Bruin" a écrit dans le message de news: ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling for a particuler item of Excel 2007 help
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" a écrit dans le message de news: ... I update the page today http://www.rondebruin.nl/id.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Aeronav" wrote in message ... Thanks for your reply, it works now if I write "Aplication.Assistance.ShowHelp "HV10093546", "DEV" "Ron de Bruin" a écrit dans le message de news: ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling for a particuler item of Excel 2007 help
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" wrote in message ... 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" a écrit dans le message de news: ... I update the page today http://www.rondebruin.nl/id.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Aeronav" wrote in message ... Thanks for your reply, it works now if I write "Aplication.Assistance.ShowHelp "HV10093546", "DEV" "Ron de Bruin" a écrit dans le message de news: ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
| What replaces the Data/form menu item in Excel 2007? | New Users to Excel | |||
| Disabled item in Excel 2007 | New Users to Excel | |||
| Custom Menu item disappeared in Excel 2007 | Excel Programming | |||
| Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
![Aeronav[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
