+ Reply to Thread
Results 1 to 2 of 2

Excel 2007/2010 - Set "save as" file extension depend on file content type

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    Mainz, Germany
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel 2007/2010 - Set "save as" file extension depend on file content type

    That's my task:

    I have Excel files build with HTML content having the file extension .xls

    <html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40">

    For older Excel versions the file will be opened as a "normal" Excel document.



    Since Excel 2007 there are two problems I have to find a solution for:

    1. Stop the startup extension warning because the file content doesn't match the extension.
    I solved this problem with a registry entry that stops the extension check (see: http://blogs.msdn.com/b/vsofficedeve...n-warning.aspx)

    2. Set "save as" file extension depend on file content type
    When the user changes the document (the document with the html content) and selects "save as" in the file type dropdown "html" is selected.
    This selection depends on the file content (I tried it with xml. In this case "xml" is selected).
    But the user always want to save the file as .xlsx so it's a useless work to change the type every time.

    -> How can I set the default "save as" file extension for html content to .xlsx?

    Thank you very much!

  2. #2
    Registered User
    Join Date
    01-20-2012
    Location
    Mainz, Germany
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel 2007/2010 - Set "save as" file extension depend on file content type

    Nobody an idea?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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