Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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, Ill explain you the issue in general. Im 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€ť. Lets 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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Office 2007 Bulk Conversion Help | Excel Discussion (Misc queries) | |||
Microsoft Office 2007 - Excel | Excel Worksheet Functions | |||
how do I set tabs in Microsoft Office Excel 2007? | Excel Worksheet Functions | |||
Microsoft Office 2007 | Excel Discussion (Misc queries) | |||
Slow Microsoft Office Excel 2007 | Excel Discussion (Misc queries) |