+ Reply to Thread
Results 1 to 38 of 38

Routine no longer working in Excel Module?

Hybrid View

meridian2000 Routine no longer working in... 06-17-2009, 06:59 AM
romperstomper Re: Routine no longer working... 06-17-2009, 07:23 AM
meridian2000 Re: Routine no longer working... 06-17-2009, 07:28 AM
romperstomper Re: Routine no longer working... 06-17-2009, 07:30 AM
meridian2000 Re: Routine no longer working... 06-17-2009, 07:33 AM
meridian2000 Re: Routine no longer working... 06-17-2009, 07:39 AM
romperstomper Re: Routine no longer working... 06-17-2009, 07:43 AM
meridian2000 Re: Routine no longer working... 06-17-2009, 07:46 AM
romperstomper Re: Routine no longer working... 06-17-2009, 07:38 AM
romperstomper Re: Routine no longer working... 06-17-2009, 08:10 AM
  1. #1
    Registered User
    Join Date
    06-17-2009
    Location
    Morden,England
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Routine no longer working in Excel Module?

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

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,968

    Re: Routine no longer working in Excel Module?

    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.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    06-17-2009
    Location
    Morden,England
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Routine no longer working in Excel Module?

    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

  4. #4
    Registered User
    Join Date
    06-17-2009
    Location
    Morden,England
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Routine no longer working in Excel Module?

    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?

  5. #5
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,968

    Re: Routine no longer working in Excel Module?

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

  6. #6
    Registered User
    Join Date
    06-17-2009
    Location
    Morden,England
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Routine no longer working in Excel Module?

    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

  7. #7
    Registered User
    Join Date
    06-17-2009
    Location
    Morden,England
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Routine no longer working in Excel Module?

    I've just looked in the options within Excel looked at the General Tap, the default file loacation is the same on both pc's

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1