.xlsm

I have a scenario where I am attempting to convert .xlsm files to .xlsx. Scenario:1. Browse to a folder with say 500 .xlsm files 2. Open each file, strip out the macro code and save as a non-macro enabled file(.xlsx). I have code that achieves the above scenario; however, all of the .xlsm...

Morning all, I have this code below written to save my spreadsheet Dim Path As String Dim filename As String Path = "Private File Path" filename = Range("Y2") + Range("Y1") ActiveWorkbook.SaveAs filename:=Path & filename & ".xlsm", FileFormat:=xlNormal The issue I have is...

I have a userform in VBA that I've been writing code for. When I right click on the form and click 'View Code', nothing happens. No errors, pop ups, etc, just nothing. I made a new user form in the same workbook and right clicked that and clicked 'View Code' and that brought up the Code window...

In an XLSM doc I am getting an error on the line below. It happens when the user tries to save the workbook as the existing workbook name. Thanks in advance Run-time error '91': Object variable or With block variable not set ExternalLinks = DestinWB.LinkSources(Type:=xlLinkTypeExcelLinks)...

I just recorded a macro that I saved to my Personal Macro Workbook on my mac computer with Excel for Mac 2011. I want to share this with my co-worker who has a PC with Excel 2007. I saved the file with the macro recording saved as an .xlsm and then e-mailed it to him, but we couldn't figure out...

I have a macro enabled document (.xlsm) that I want to save as a standard macro-free document (.xlsx). I am able to do it but it creates a popup asking me if I want to do it and lose the macros. Is there a way to avoid the popup and have it just save the document without the macros...

I have a file in .xlsm format that I have emailed to several recipients. A few people get the error "Excel cannot open the file "filename.xlsm" because the fie format or file extension is not valid". Most of the recipients can open the file, and so can I, so I know it's not corrupt. I have...