View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VanS[_2_] VanS[_2_] is offline
external usenet poster
 
Posts: 60
Default Error opening Excel app via automation

Hello,
I have a VB6 exe front end that opens an Excel VBA app via automation. I am
running it under a Virtual PC Win 2k Office 2K testbed. I have previously run
it without problem on my host Win XP Pro Office 2003 system. The Excel VBA
portion opens without problem when opened directly, but when I try to open it
via the VB exe via automation it bombs out with "Program error(title)
Application.exe has generated errors and will be closed by Windows. Please
restart your program. An error log is being created." When I check the
drwtsn32.exe log, it shows the following error for the exe: "Exception
number: C0000005 (access violation)"
I don't know a lot about Win 2K permissions, but I am quite sure this is set
up under an Admin account.
Do I need to set permissions here and if so how do I do that? Or any idea
what wrong and how to fix?
Thanks, God bless
Van