Windows 7 :Windows 7 keeps closing Excel during macro debugging

**zero212** · 02-28-2011, 06:39 AM

Hi I am new to this forum and was hoping someone may be able to help me with this problem.
I am using macros in my Excel 2007 files and recently got a new computer with Windows 7 64-bit Professional on it. I wanted to add more functionality to my workbook but there was some problem with the code.
When I hit 'Debug' it went to the code in VBA and 10 seconds later Windows was busy closing Excel - "Excel has stopped working". This happens every time no matter what I do!

I don't think this has to do with faulty Office products but the fact that Windows 7 sees Excel as non-responsive although I think it is only paused while I am stepping though the code!
Any ideas?

**royUK** · 02-28-2011, 07:23 AM

It's hard to say without seeing what you are doing

**zero212** · 03-02-2011, 08:40 AM

Hi there sorry I got a bit distracted with work...
I am using this function (got it from somewhere) to resolve the network path which may be compromising the rest of the file (I don't have previous experience with this one):

Please Login or Register  to view this content.

and using it in a function later on in the macro:

Please Login or Register  to view this content.

My aim is to automatically put correct hyperlinks in the sheet to other excel files on our network (i.e. this file would be like a summary/directory from which to access the other files). I have another function which then retrieves some values from these other excel files but it seems to be crashing before then.