|
I want to be able to open Excel XML files in Excel but without assigning XML directly to Excel. There are lots of XML files that are not Excel files and I don't want to open all of them in Excel. The file has proper header for opening in Excel but currently it does open Internet Explorer that asks me if I want to open the file with Excel, save or cancel. I just want to open it without two another annoying windows.
| |||
feedback
|
|
Are you not able right click and choose "Open With" -> Excel ? | |||
feedback
|
|
you can create a vbscript that suppresses messages from excel and opens your xml files directly in excel.. Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open _ ("C:\Scripts\New_users.xls") If you use these specifiers you will not be prompted about the file, read only, etc... objExcel.Workbooks.(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) | |||
|
feedback
|
|
You can register the xml filetype with Microsoft XML Editor. This will allow xml files to be opened directly with their registered application (e.g. Excel), as outlined in this answer from Stackoverflow. | ||||
|
feedback
|
|
Locally you could just do excel.exe ? Or did I understand something wrong? | |||
|
feedback
|
