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?
Bookmarks