+ Reply to Thread
Results 1 to 6 of 6

Start Up Switch Being Ignored

  1. #1
    Registered User
    Join Date
    07-23-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Start Up Switch Being Ignored

    I have an Excel 2003 workbook that is being invoked from a shortcut. The Short cut has the following target:
    "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "C:\TEMP\Application.xls" /e/PREFIX/C:\TEMP

    Within Application.xls, I have some VBA code that reads the command line string and extracts the parameter list:
    Please Login or Register  to view this content.
    This works fine on more than one workstation here, but when the same process is run at another site, the startup switch is missing from the command line.

    Does anybody know of any reason why this may be happening?
    Last edited by romperstomper; 07-23-2010 at 09:40 AM. Reason: Added code tags

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

    Re: Start Up Switch Being Ignored

    Hi, and welcome to the forum.
    In future, when posting code, please enclose it in code tags to improve legibility (and comply with forum rules). I've done it for you on this occasion.

    First question: are all workstations using the same version of Office/Windows including SPs?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    07-23-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Start Up Switch Being Ignored

    Thanks for that.

    Yes, all workstations are using the same versions.

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

    Re: Start Up Switch Being Ignored

    And the startup shortcuts are definitely all the same - no spaces at all following the /e?

  5. #5
    Registered User
    Join Date
    07-23-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Start Up Switch Being Ignored

    That's right. Everything seems to be identical across all workstations. I can't spot anything obviously wrong. All I can think is that it's something in the way that Excel has been installed, but I'm just guessing.

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

    Re: Start Up Switch Being Ignored

    Have you debugged the code at the problem site? Is it definitely that the GetCommandLine call is returning the shortened string?

+ 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