LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Crash attempting to open Excel Add-in using .dll file comprised of VB6 code

Hi there,

I'm getting a crash when my .dll file (comprising of VB6 6.0.9782 code)
attempts to open an Excel 2000 Add-in (.xla file) comprising of VBA
6.0.8714 code.

Here's the scenario,

1) .dll file is registered with Excel 2000
2) Double clicking on an Excel Workbook in Explorer - Excel Opens,
Workbook Opens
3) .dll file has an appevent associated with the Workbook Open event
4) .dll file triggers the opening of the Excel Add-in

Here's the line where it crashes:

gEventHandler.oXL.Workbooks.Open sXLAPath, 0

where gEventHandler = Event Handler class object
oXl = Excel.Application
sXLAPath = the entire path of the .xla's location (including the
filename.xla)

The crash is something along the lines of "instruction at 0x30033c38
referenced memory at 0x00000002. The memory could not be written"

Any ideas to this problem?
Thansk in advance.
CM

 
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
"Read Only" error when attempting to open EXCEL file Jim Excel Discussion (Misc queries) 1 January 27th 10 06:28 AM
File crash when I try to open GOH Excel Discussion (Misc queries) 0 May 21st 08 02:40 PM
Word and Excel crash when I try to open a folder to get to a file DGD41 Excel Discussion (Misc queries) 7 April 15th 06 09:14 PM
"Frontpage " message appears on attempting to open excel stewart reid Excel Discussion (Misc queries) 1 September 14th 05 04:32 PM
stubborn Excel crash when editing code with code, one solution Brian Murphy Excel Programming 0 February 20th 05 05:56 AM


All times are GMT +1. The time now is 06:21 AM.

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

About Us

"It's about Microsoft Excel"