IS THERE ANYONE THAT CAN HELP ME!!

[vbawannabe]

THIS IS THE ERROR MESSAGE I GET MANY TIMES WHEN I AM USING VBA WITH EXCEL.......I SAVE THE FILE TO A SERVER AND I DONT KNOW WHAT HAPPENS BUT FILE STARTS TO ACT UP.
THIS MESSAGE BELOW IS ONE I GET CONSTANTLY WHEN I PROGRAM WITH VB


EXCEL caused an invalid page fault in
module EXCEL.EXE at 0167:3029d532.
Registers:
EAX=00000000 CS=0167 EIP=3029d532 EFLGS=00010246
EBX=00000000 SS=016f ESP=0062dbbc EBP=0062dbe0
ECX=004c18f8 DS=016f ESI=0079e660 FS=5457
EDX=7ff21a78 ES=016f EDI=0079eb40 GS=0000
Bytes at CS:EIP:
8b 08 ff 51 24 39 5d fc 89 45 f0 75 03 89 45 fc
Stack dump:
00000000 00000000 00000001 00000001 00000000 00000000 301ec3ba 00000000 00000000 0062dd9c 300af9cd 007e0230 00000001 00000001 00000000 00000000

 

[dsi]

Is this happening when you run the code or when you are programming? Does it happen in the same spot in your program? You may need to be more specific.

 

[dsb]

Are you using API's?
Many APIs are not potty-trained; assuming that you
will set up the calling parameters right.

Dumps such as yours can be the result of feeding
such an API with bad food.

You will have to publish the code to get help on this....I'd be interested in how you are able to do thi

 

[vbawannabe]

to be more specific.... the error occurs mostly when (vba closes excel automatically when user logs out of the spreadsheet) vba begins to close program and something happens like the connection to the server is interrupted or the server crashes etc....another thing is that i programmed one spreadsheet to minimize in the taskbar while closing and if while vba was closing it i clicked on the icon in the taskbar...whamo i lost my data. and got above error message when i would reopen file.

funny thing is is that when this error occurs i get msgbox that says program will close and it does but when i press ctrl+alt+del it is still running in the list of programs

is there a way to recover this info after this has happened?