Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default html chm help file won't launch from VBA, sometimes

I am using xl2003 and the API way of launching an html help file.
Everything works great most of the time, but sometimes the chm file
refuses to launch.

Has anyone experienced this behavior, and have any solution?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default html chm help file won't launch from VBA, sometimes

It always launches for me. Assuming of course all the API arguments are
"appropriate".

Regards,
Peter T

"xlrotor" wrote in message
...
I am using xl2003 and the API way of launching an html help file.
Everything works great most of the time, but sometimes the chm file
refuses to launch.

Has anyone experienced this behavior, and have any solution?

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default html chm help file won't launch from VBA, sometimes

When it stops launching, I have to exit and restart excel to get it
working again.

It's possible it might have something to do with VBA compiling the
code while a "handle" to the html file is floating around somewhere.

Brian
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default html chm help file won't launch from VBA, sometimes

Your explanation makes sense but I couldn't recreate any problem. I did
this -

Launched a chm with the html-help API in my xla
Manually closed the chm
Recompiled the xla with Debug - Compile
Re-launched the chm with the API - worked fine.

I could be wrong but I think the API driven chm is attached to a 'Process',
which is the Excel instance not the VBA project. If so, maybe even
recompiling the project is not relevant.

Regards,
Peter T


"xlrotor" wrote in message
...
When it stops launching, I have to exit and restart excel to get it
working again.

It's possible it might have something to do with VBA compiling the
code while a "handle" to the html file is floating around somewhere.

Brian



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default html chm help file won't launch from VBA, sometimes

I've tried, although not exhaustively just yet, to find a repeatable
set of circumstances that leads to the failure to display.

I'm getting ready to ship a new release of my Excel application to my
users. I want to make the switch from old style HLP to HTML CHM help
because Vista doesn't autmatically support HLP, evidently for security
reasons. I'm pretty happy with how my converted CHM file has turned
out (I use ForeHelp).

This little problem of occasionally losing the ability to display the
CHM file is the only open issue.

When I figure it out, I'll post back what I found. Hopefully sooner
than later.

Brian



On Mar 26, 3:16 am, "Peter T" <peter_t@discussions wrote:
Your explanation makes sense but I couldn't recreate any problem. I did
this -

Launched achmwith thehtml-help API in my xla
Manually closed thechm
Recompiled the xla with Debug - Compile
Re-launched thechmwith the API - worked fine.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xls file will not launch atlantic grouper Excel Discussion (Misc queries) 7 May 7th 09 04:20 PM
File won't launch eric blom Excel Discussion (Misc queries) 1 September 17th 07 10:30 PM
Launch a .bat file with VBA [email protected] Excel Programming 8 October 23rd 06 06:36 PM
Macro launch - Button vs Manual launch , has different results. Wayne Excel Programming 4 February 23rd 05 11:33 AM
Unable to launch html helpfile RB Smissaert Excel Programming 0 July 19th 03 01:49 AM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"