Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
In a Win 2000 system, among other things, the following are installed:
1. VB 6 Enterprise. 2. MSDN October 2001 Library 3. Office 2003 Professional 4. VS .NET 2003 Professional. When I highlight a VBA statement, and hit F1, or enter, say, Collapse, in the object browser, I get a message that says "Unable to display Help". I realize that the MSDN Oct 2001 library has nothing for Office 2003. How can I get VB 6 to display Help for Office 2003 critters? The critters get listed in the object browser, but no help can be obtained -- http://www.standards.com/; See Howard Kaikow's web site. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
Try
http://support.microsoft.com/default...34&Product=vb6 It may not pertain directly but it also contains links to 2 other articles. If nothing else, you could try the re-register technique described in the article on the VBA help files and see if that helps. Good Luck, -- George Nicholson Remove 'Junk' from return address. "Howard Kaikow" wrote in message ... In a Win 2000 system, among other things, the following are installed: 1. VB 6 Enterprise. 2. MSDN October 2001 Library 3. Office 2003 Professional 4. VS .NET 2003 Professional. When I highlight a VBA statement, and hit F1, or enter, say, Collapse, in the object browser, I get a message that says "Unable to display Help". I realize that the MSDN Oct 2001 library has nothing for Office 2003. How can I get VB 6 to display Help for Office 2003 critters? The critters get listed in the object browser, but no help can be obtained -- http://www.standards.com/; See Howard Kaikow's web site. |
#3
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
I've met this problem, too. Never tracked it down to ultimate causes, but it
seems to relate to the way in which the products were installed: eg if you installed everything as Administrator, then run things as a plebeian user (or vice versa?). Quick fix is to find the help files and create desktop shortcuts. Doesn't fix the F1 issue, but at least the help is readily to hand. "Howard Kaikow" wrote in message ... In a Win 2000 system, among other things, the following are installed: 1. VB 6 Enterprise. 2. MSDN October 2001 Library 3. Office 2003 Professional 4. VS .NET 2003 Professional. When I highlight a VBA statement, and hit F1, or enter, say, Collapse, in the object browser, I get a message that says "Unable to display Help". I realize that the MSDN Oct 2001 library has nothing for Office 2003. How can I get VB 6 to display Help for Office 2003 critters? The critters get listed in the object browser, but no help can be obtained -- http://www.standards.com/; See Howard Kaikow's web site. |
#4
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
My account is part of the Administrator group, so that should not be the
problem. Rather than creating shortcuts, I start an instance of Word/Excel, in addition to the VB 6 design window. But this is a crock that MSFT needs to fix ASAP. -- http://www.standards.com/; See Howard Kaikow's web site. "Jezebel" wrote in message ... I've met this problem, too. Never tracked it down to ultimate causes, but it seems to relate to the way in which the products were installed: eg if you installed everything as Administrator, then run things as a plebeian user (or vice versa?). Quick fix is to find the help files and create desktop shortcuts. Doesn't fix the F1 issue, but at least the help is readily to hand. "Howard Kaikow" wrote in message ... In a Win 2000 system, among other things, the following are installed: 1. VB 6 Enterprise. 2. MSDN October 2001 Library 3. Office 2003 Professional 4. VS .NET 2003 Professional. When I highlight a VBA statement, and hit F1, or enter, say, Collapse, in the object browser, I get a message that says "Unable to display Help". I realize that the MSDN Oct 2001 library has nothing for Office 2003. How can I get VB 6 to display Help for Office 2003 critters? The critters get listed in the object browser, but no help can be obtained -- http://www.standards.com/; See Howard Kaikow's web site. |
#5
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
THanx. I'll give those a look see.
-- http://www.standards.com/; See Howard Kaikow's web site. "George Nicholson" wrote in message ... Try http://support.microsoft.com/default...34&Product=vb6 It may not pertain directly but it also contains links to 2 other articles. If nothing else, you could try the re-register technique described in the article on the VBA help files and see if that helps. Good Luck, -- George Nicholson Remove 'Junk' from return address. "Howard Kaikow" wrote in message ... In a Win 2000 system, among other things, the following are installed: 1. VB 6 Enterprise. 2. MSDN October 2001 Library 3. Office 2003 Professional 4. VS .NET 2003 Professional. When I highlight a VBA statement, and hit F1, or enter, say, Collapse, in the object browser, I get a message that says "Unable to display Help". I realize that the MSDN Oct 2001 library has nothing for Office 2003. How can I get VB 6 to display Help for Office 2003 critters? The critters get listed in the object browser, but no help can be obtained -- http://www.standards.com/; See Howard Kaikow's web site. |
#6
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
"Howard Kaikow" wrote in message ... My account is part of the Administrator group, so that should not be the problem. Rather than creating shortcuts, I start an instance of Word/Excel, in addition to the VB 6 design window. But this is a crock that MSFT needs to fix ASAP. You're right, but I wouldn't hold your breath. |
#7
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
Excel 2003 VBA Help not working when automating via VB 6
In the process of investigating whether I had a proper vshelp.dll file, I
found something interesting. System is a multiboot system, with a different Office in each boot system. Using windoze explorer, I did a search for vshelp.dll, A copy was found on the C and F drives, but none on the G and J drives. So I manually looked for the file on the G and J drives. Files are present. So, one bug is that windoze explorer missed listing the files in the Search on the G and J drives. Office 2003 is in the OS on the J drive. I searched thru the registry and found that vshelp.dll was already registered on the J drive, but I ran regsvr32 anyway. The F1/Help problem continues. MSFT needs to issue a fix, not tell us to do tumblesaults as in KB article 216109. MSFT has greatly improved the functionality, performance and ease of use in Office over the years, but they still need to get their act together on installation issues. -- http://www.standards.com/; See Howard Kaikow's web site. "Jezebel" wrote in message ... "Howard Kaikow" wrote in message ... My account is part of the Administrator group, so that should not be the problem. Rather than creating shortcuts, I start an instance of Word/Excel, in addition to the VB 6 design window. But this is a crock that MSFT needs to fix ASAP. You're right, but I wouldn't hold your breath. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating a worksheet in Excel 2003 | Excel Worksheet Functions | |||
excel 2003 not working | Excel Discussion (Misc queries) | |||
MS Excel 2003 automating new worksheet & transfer balances | New Users to Excel | |||
Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
Automating Excel w VB.Net 2003 | Excel Discussion (Misc queries) |