Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macros/Short cuts (2003)

    Ok...I have a spreadsheet that was designed by a staff member who is not longer here. I need some help. This are some macros and VB code in the background that runs a Vlookup and Hlookup automatically based on today's date. If I open the spreadsheet straight from the drive....I get incorrect information.. If I open the spreadsheet from a shortcut on the desktop....it works without any problems. WHY?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macros/Short cuts (2003)

    We'd have to see the workbook, or at least the code, I'm afraid.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Macros/Short cuts (2003)

    Are they opening the same spreadsheet?

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros/Short cuts (2003)

    YES...just two different way to get into it.

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macros/Short cuts (2003)

    1. <LI>Is Excel running prior to the workbiook being opened? In both cases?
      <LI>Further to Steve's question; I would not rest easy until I had run the following command in the VBE Immediate window for both instances. Too often I have been caught with what I believed to be a single file, only to find a slight difference when seeing the two pathnames, one immediately above the other.
    ?ActiveWorkbook.FullName
    Regards
    Don

Posting Permissions

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