+ Reply to Thread
Results 1 to 7 of 7

Message "parametervalue.xlsx could not be found. Check spelling..."

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Lafayette, La
    MS-Off Ver
    Excel 2010
    Posts
    4

    Message "parametervalue.xlsx could not be found. Check spelling..."

    I have 2 issues.

    I am starting Excel (2010) from within another application, sending the name of the spreadsheet to open (somename.xls) and a parameter (which contains a comma separated list of numbers ) to use to filter the spreadsheet once it's open. I have VBA code that turns the list into an array and uses that as the criteria for filtering. That works.

    But once the spread sheet opens and displays my filtered list of rows, I receive a message similar to this:

    11274,14075.xlsx could not be found. Check the spelling of the name and verify that the file location is correct. If you are trying to open the file from your list of most recently.....

    11274,14075 is actually the information in the parameter, not the name of the spreadsheet.

    And, I'm not even trying to open an xlsx spreadsheet, rather an xls spreadsheet.

    Then when I close the spreadsheet, Excel asks me if I want to save it. It's a read-only file, so I don't want the user to save it, I'd like to suppress the save message.

    I've seen some reference to setting registry values, re-registering Excel, changing options on the File type Open statement, and have tried all of those things.

    I only started getting this message when I open a spreadsheet programatically like this. If I double-click on it directly, it opens with no error.
    This is my execution string:

    C:\Program Files\Microsoft Office\Office14\excel.exe O:\SegmentHistory2.xls /e/r/ 11274,14075

    Any suggestions as to how to get rid of the first message, and how to suppress the Save dialog?

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    Your string should look like this if all you want to do is open the file.

    Please Login or Register  to view this content.
    Last edited by JapanDave; 06-20-2012 at 01:10 PM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    Lafayette, La
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    I want to open the spreadsheet and use the parameter value to filter the rows. That part is working. I'd like to get rid of the message that is looking for a spreadsheet that doesn't exist and I'm not trying to open.

  4. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    Post a sample workbook, I am not exactly sure what you are trying to do in this string.

    You will always get that error using this code.
    Please Login or Register  to view this content.
    Last edited by JapanDave; 06-20-2012 at 01:14 PM.

  5. #5
    Registered User
    Join Date
    06-20-2012
    Location
    Lafayette, La
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    I don't have WorkBooks.Open anywhere in my VBA code.

    I'm opening Excel from another application. That application is executing:

    "C:\Program Files\Microsoft Office\Office14\excel.exe O:\SegmentHistory2.xls /e/r/ 11274,14075"

    In the Excel documentation, it says you can open Excel with switches and parameters. The /e/r are the switches I want to use (no startup screen, read only) the rest, " / 11274,14075" is a parameter (comma separated list of numbers).

    VBA code in the spreadsheet parses the command line parameters and uses that list to filter the records.

    Why does it think I want to open a spreadsheet named "11274,14075.xlsx"?

  6. #6
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    Use code tags to post your code.

    See if this is what you need, You may need to fiddle with it. But this is the extent of my knowledge in regards to this. So if this does not work, maybe an expert can chime in.

    Please Login or Register  to view this content.
    Last edited by JapanDave; 06-20-2012 at 01:29 PM.

  7. #7
    Registered User
    Join Date
    06-20-2012
    Location
    Lafayette, La
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Message "parametervalue.xlsx could not be found. Check spelling..."

    Same result.

    It's looking for an xlsx with the name being my parameter list. e.g. 12345,32145.xlsx

    Does anyone else have any suggestions?

+ 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