Routine no longer working in Excel Module?

**meridian2000** · 06-17-2009, 07:28 AM

thanks for the reply romperstomper, just tried your suggestion but alas it doesn't work still

**romperstomper** · 06-17-2009, 07:30 AM

Have you tried restarting Excel? I'm guessing you are using an application level event sink? If so, it may be that the variable has been reset.

**meridian2000** · 06-17-2009, 07:33 AM

Hi, yes I've tried restarting Excel, this problem has been going for weeks, the whole pc has been restarted many times, I've 2 pc's on my desk, both with the same software, one works the other doesn't. It's as if Excel dosn't know the personal.xls sheet is there

**meridian2000** · 06-17-2009, 07:39 AM

I've just noticed one thing a bit strange, if I just open up the file I'm using by double clicking it on the first pc, then open up Visual Basic Editor, I see the file personal.xls in the list, if I open it on the other pc (same file) and look in the visual basic editor, it isn't in the list, is this of any help?

**romperstomper** · 06-17-2009, 07:43 AM

That would imply that on the other PC Personal.xls is either missing or is not in one of the XLSTART directories.

**meridian2000** · 06-17-2009, 07:46 AM

My thoughts exactly, but I've check and the setup is identical on both pc's, I've even copied the working personal.xls from the working pc to the other one, still no luck... by the way, thanks for your patience