Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
Export to Excel - error "Type MisMatch"

Answered Export to Excel - error "Type MisMatch"

  • Tuesday, April 03, 2012 3:42 PM
     
     
    Sign In to Vote
    0
    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

     

All Replies

  • Tuesday, April 03, 2012 5:32 PM
    Owner
     
     Answered
    Sign In to Vote
    1

    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

    • Marked As Answer by Andy Schneider Tuesday, April 03, 2012 6:06 PM
    •  
     
  • Friday, April 27, 2012 8:14 PM
     
     
    Sign In to Vote
    0
    I am having the same issue. Still not resolved
     
  • Monday, April 30, 2012 3:18 PM
    Owner
     
     
    Sign In to Vote
    0

    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

     
  • Tuesday, May 01, 2012 9:31 AM
     
     
    Sign In to Vote
    0
    I have Windows 7 and the problem still ocurr. :)
     
  • Tuesday, May 01, 2012 4:25 PM
    Owner
     
     
    Sign In to Vote
    0

    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