Apr 16, 2018 Open Application Support, and then open Microsoft. Open Office 2011 AutoRecovery. On the Edit menu, click Select All. Drag all files into 'New Folder' on the desktop. The AutoRecovery folder should be empty. Open Excel for Mac 2011 and try to save a file.
New iMac with Excel 2011 opens spreadsheet, but macros will not run. Work was created on Excel for Microsoft OS.After opening, there is a splash screen that reads 'This workbook contains macros. Do you want to disable macros before opening the file' We click Enable Macros. The file opens successfully and the data is available to view. New data can be input in the workbook, but if the macro button is pressed we get the 'Compile error. Cant find project or library' message.
The macros also give us issues on Windows OS installs; however we have found that the fix is to add the MSCOMCT2.OCX file to the appropriate sys32 folder. We also need to be sure there is a valid date in the 'last record' created. The fix on the IOS system has not been as simple.
The iMac code that is first displayed in the debugger is below. The workbook is attached, but all client info has been deleted. This may have some effect on function of the macro, but it is sensitive information.
Compile error. Cant find project or library.
![This Workbook Includes Content That Is Not Supported By Excel For Mac 2011 This Workbook Includes Content That Is Not Supported By Excel For Mac 2011](/uploads/1/2/5/8/125882416/693595926.png)
Private Sub UserForm_initialize()
Dim b As Integer
DTPicker1 = Date
DTPicker3 = Date
DTPicker4 = Date
![Not Not](https://support.content.office.net/en-us/media/7dc7873f-84f8-481c-9f3f-2f5851ea712a.png)
'Sheet4.Visible = xlSheetVisible '(show sheet to make changes)
If WorksheetFunction.CountA(Cells) > 0 Then
M = ActiveSheet.Cells.Find(what:='*', after:=[A1], _
searchorder:=xlByRows, _
searchdirection:=xlPrevious).Row
End If
You expect Excel for Mac 2011 to open Excel files, of course, but the program can do more than that. You can actually open, work on, and save a file in several formats. Choose File→Save As and then click Format to open the pop-up menu. Excel can open and save in the formats listed in this Format pop-up menu.
You have several options for file formats besides Excel’s default (.xlsx) format:
- Excel Template (.xltx): Saves the workbook as a template, which you can open in the My Templates section of the Excel Workbook Gallery. You can also open templates by choosing File→Open and selecting Excel Templates from the Enable pop-up menu. This format does not have macros and is another open XML format.
- Excel Macro-Enabled Workbook (.xlsm): Workbooks in this XML format contain Visual Basic for Applications (VBA) programming language code, or Excel 4.0 macro code. When opening this format file, Excel displays a prompt asking whether you want to remove the macros contained in the file. The default is Disable Macros. You must instead click Enable Macros if you want macros to run.
- Excel Macro-Enabled Template (.xltm): The same as .xlsm, except this is a template. The macro warning dialog displays when you open a workbook in this format, and you must click Enable Macros if you want macros to run.
- Excel Add-In (.xlam): Saves a macro-enabled workbook as an Excel add-in.
- Excel Binary Workbook (.xlsb): This is the most compact file format, and is recommended for large files. This format doesn’t conform to open source standards.
- Comma Separated Values (.csv): Saves a worksheet data table as text separated by commas. This format is text only. All other content is discarded.
- Web Page (.htm): Save the workbook in a format that Web browsers understand and can display. Excel creates a file in HTML format, along with a supporting folder. Upload both the file and folder to a Web server if you want to share your workbook via the Internet.
Excel can open and save Web pages in HTML (HyperText Markup Language) format and do great things with Web tables and data from the Web, but don’t uninstall your HTML (Web page) code editor. Excel can’t replace that.