senators40
Technical User
Hi,
I have a 10 MB excel macro that uses userforms with windows NT 4.0 and Excel 97.
When I open the excel file I have a button that the user can press to run the program. It runs through the module to get the first userform. After it goes through the first userform and I click on the correct button it gives me an excel.exe violation error called
Exception number: c0000005 (access violation)
address 0x00000000
App: excel.dbg (pid=281) (I found this when I went to the Dr Watson file for Windows NT)
I have figured out a workaround that if the visual basic editor is open the error does not happen. How do I get the visual basic editor to open. I have tried to use the sendkeys feature but it does not seem to open visual basic editor while the program is running.
Any help would be appreciated
Jeff
I have a 10 MB excel macro that uses userforms with windows NT 4.0 and Excel 97.
When I open the excel file I have a button that the user can press to run the program. It runs through the module to get the first userform. After it goes through the first userform and I click on the correct button it gives me an excel.exe violation error called
Exception number: c0000005 (access violation)
address 0x00000000
App: excel.dbg (pid=281) (I found this when I went to the Dr Watson file for Windows NT)
I have figured out a workaround that if the visual basic editor is open the error does not happen. How do I get the visual basic editor to open. I have tried to use the sendkeys feature but it does not seem to open visual basic editor while the program is running.
Any help would be appreciated
Jeff
