If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft Office 2007 is used on a XP machine....
Dear,
I use the following system with a customer of mine: Microsoft Windows XP Professional Edition - Version 2002 - Service Pack 3. Microsoft Office 2007 is used on the XP machine. As the report information of the customer is confidential, I’ll explain you the issue in general. I’m sure that you can recognize the context of this scenario. Starting from an internal web application, the user can generate report results via the web page link “Detailed Results in html format” or the web page link “Detailed Results in xls format (tab delimited text)”. There is no issue in using the web page link “Detailed Results in html format”. Let’s focus on the web page link “Detailed Results in xls format (tab delimited text)”. A click on the web page link generates the message “File download – Do you want to open or save this file?” The file type mentioned in this message is “Microsoft Office Excel 97-2003 Worksheet, 110KB”. Regarding this action, there are three options: - Save the file: there is no issue in saving the file. - Cancel: there is no issue in cancelling the action. - Open the file: topic to discuss. Step 01: After pushing the “Open” button, it looks like the system is pending…. Step 02: I click on the “Show Desktop” icon (which is available in the taskbar at the bottom of the screen). There is of course also a task available related to the active web application in the taskbar at the bottom of the screen. Step 03: If I click on this task, the following Microsoft Office Excel message appears: “The file you are trying to open, [Filename], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?” Step 04: I confirm this message by pushing the “Yes” button. The report results become available in Microsoft Excel. Conclusion: the Microsoft Office Excel message in step 03 appears in the background instead of in the foreground. Question: what might be the reason for this and how could we please solve this issue? Thank you. -- Kind Regards, Gaston |
#2
|
|||
|
|||
Microsoft Office 2007 is used on a XP machine....
Gaston wrote:
Detailed Results in xls format (tab delimited text) ... The file type mentioned in this message is Microsoft Office Excel 97-2003 Worksheet, I think the clue lies in those 2 lines. If the file is a tab delimited text file but has an xls extension it is not surprising that you get the message: The file you are trying to open, [Filename], is in a different format than specified by the file extension. I would think that you need to change the file extension used to be .txt or .prn (I am not expert in web page links so I can't help you to achieve that; you could seek help in a forum that specialises in web page design). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Microsoft Office 2007 is used on a XP machine....
Hi Bill,
Thank you for giving feedback. My question was: the Microsoft Office Excel message in step 03 appears in the background instead of in the foreground. What might be the reason for this and how could we please solve this issue? We have solved this issue by doing the following actions: Control Panel - Folder Options - File Types - select the extension "xls" - push the Advanced button - select the action "New" - activate the flag "Browse in same window". Kind Regards, Gaston "Bill Manville" wrote: Gaston wrote: Detailed Results in xls format (tab delimited text) ... The file type mentioned in this message is Microsoft Office Excel 97-2003 Worksheet, I think the clue lies in those 2 lines. If the file is a tab delimited text file but has an xls extension it is not surprising that you get the message: The file you are trying to open, [Filename], is in a different format than specified by the file extension. I would think that you need to change the file extension used to be .txt or .prn (I am not expert in web page links so I can't help you to achieve that; you could seek help in a forum that specialises in web page design). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|