如果工作簿包含 VBA 宏,请将模块从旧工作簿复制到新工作簿。 选项3:将文件另存为其他 Excel 文件类型 在“文件”菜单上,选择“另存为”。 在“另存为类型”列表中,选择当前文件格式以外的文件格式。 如果使用 Microsoft Excel 2007 或更高版本,请将该文件另存为 .xlsx 或 .xlsm,而不是 .xls
However, if you had previously tried one of the methods to fix this error and it did not help, you can jump to another method quickly from this list: Method 1: Check whether you exceed limits Method 2: Make sure only one instance of Excel is active Method 3: Close all app...
And this snippet for check if the file is open or not prettyprint 複製 Private Function FileInUse(ByVal path As String) As Boolean Try Using fs As FileStream = New FileStream(path, FileMode.OpenOrCreate) End Using Return False Catch ex As IOException Return True End Try End Function Pr...
But there may be cases while you are trying to close the workbook inVBA, but the workbook is already closed. In those cases,VBAwill raise an error. To protect the code from any possible error, we’ll wrap it with an alternative solution and point it to move to that solution if necessa...
Try saving the Excel file again. #6: Delete any Visual Basic for Applications The "errors were detected while saving excel 2016" can also be fixed by deleting the Visual Basic for Applications (VBA) projects from your document. It includes simply deleting the VBA project of your document. Th...
If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except selectExcel Add-Insin step 2. Then, try each of the Excel add-ins one at a time in step 3. If Excel loads the file, the add-in that you last turned off is causing the problem...
VBA代码:在打开的工作簿中突出显示活动的工作表选项卡 Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim xSheet As Worksheet Application.ScreenUpdating = False For Each xSheet In ThisWorkbook.Worksheets If xSheet.Name = ActiveSheet.Name Then xSheet.Tab.ColorIndex = 6 Else xSheet.Tab.Color...
If your workbook contains VBA macros, copy the modules from the old workbook to the new workbook. On theFilemenu, selectSave As. In theSave as Typelist, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file...
The Idea:So if other users change the workbook name, i need a macro that when someone later hits save, it will change/rename workbook name to a specific name...
{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: VBA Macro saving files as 0kb without the data in excel","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3986160"},"parent":{"__ref":"ForumTopicMessage:message:3985531"},"bod...