none
Export to Excel - error "Type MisMatch" RRS feed

  • Question

  • I am trying to export GPO settings to Excel using SCM. I have Office 2010 installed. When I try to export to "Excel (xlsm)" I am getting a "Type Mismath" error in Excel and then the debugger opens to this line   "Debug.Assert False" I have enabled macros in excel. I should also note that I am using Win8 Consumer Preview for my OS.

    Andy Schneider http://get-powershell.com

    Tuesday, April 3, 2012 3:42 PM

Answers

  • Andy;

    We haven't tested SCM 2.5 or SCM 2.0 on Windows 8 yet. I've spoken to a couple of other people who have tried and ran into the same error with Excel. We will be starting a new project to update SCM soon, and I'm sure that we will include support for running it on Windows 8 and that we will also include guidance and baselines for Windows 8, but I have no idea what the project dates will be.

    Regards,

    Kurt


    Kurt Dillard http://www.kurtdillard.com

    Tuesday, April 3, 2012 5:32 PM
    Moderator

All replies

  • Andy;

    We haven't tested SCM 2.5 or SCM 2.0 on Windows 8 yet. I've spoken to a couple of other people who have tried and ran into the same error with Excel. We will be starting a new project to update SCM soon, and I'm sure that we will include support for running it on Windows 8 and that we will also include guidance and baselines for Windows 8, but I have no idea what the project dates will be.

    Regards,

    Kurt


    Kurt Dillard http://www.kurtdillard.com

    Tuesday, April 3, 2012 5:32 PM
    Moderator
  • I am having the same issue. Still not resolved
    Friday, April 27, 2012 8:14 PM
  • Its not something we are planning on resolving for prerelease versions of Windows 8. I expect that we will publish a new version of SCM that functions as designed on Windows 8 around the same time that Windows 8 ships, but we don't have a schedule laid out for that project yet so I have no idea what the actual dates will be for the beta program or the formal release of the next version of SCM.

    Kurt


    Kurt Dillard http://www.kurtdillard.com

    Monday, April 30, 2012 3:18 PM
    Moderator
  • I have Windows 7 and the problem still ocurr. :)
    Tuesday, May 1, 2012 9:31 AM
  • Taitai,

    What language are you running? We only tested it on computers running English and we've heard from a few people who have had issues when they try to install SCM on computers running other languages.

    Kurt


    Kurt Dillard http://www.kurtdillard.com

    Tuesday, May 1, 2012 4:25 PM
    Moderator