Excel宏文件大小 [英] Excel Macros file size

问题描述

我有一个带有宏的Excel文件.实际文件为6MB，运行Save Macro时会保存该文件，但文件大小为32MB左右，并且不包含任何宏.

I have an Excel file with macros. The actual file is 6MB and when a Save Macro runs the file is saved but its size is around 32MB and don't contain any macros.

我不知道为什么保存的文件大小大于实际文件大小.

I don't know why the saved file size is larger than the actual file size.

保存宏

Sub SaveSummaries()
    '
    ' SaveSummaries Macro
    '
    Application.DisplayAlerts = False
    ActiveWorkbook.Save
    Sheets(Array("Donor Totals", "GDBA", "DT", "CLIC", "GOSH")).Select
    Sheets("Donor Totals").Activate
    Sheets(Array("Donor Totals", "GDBA", "DT", "CLIC", "GOSH")).Copy
    ChDir "C:\Users\Chandra.Cherukuri\Desktop\Area Donor Summaries"
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\Chandra.Cherukuri\Desktop\Area Donor Summaries\Donor Summary_All Charities.xlsx", FileFormat:= _
        xlOpenXMLWorkbook, CreateBackup:=False
    ActiveWindow.Close
    Sheets("Area Summaries").Select

End Sub

任何帮助将不胜感激.

推荐答案

线索在下面:

ActiveWorkbook.SaveAs Filename:= _
    "C:\Users\Chandra.Cherukuri\Desktop\Area Donor Summaries\Donor Summary_All Charities.xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

在其中您将格式指定为 xlOpenXMLWorkbook .在这种文件格式中，您无法存储宏，它是XML文件-从本质上讲，这意味着文本文件具有很多开销(标签).

where you specify the format as xlOpenXMLWorkbook. In this file format you cannot store macros and it is an XML file - which basically means a text file with a lot of overhead (tags).

如果您要使用Open XML格式保存带有宏的工作簿，则可以使用: xlOpenXMLWorkbookMacroEnabled 选项，但是它将创建一个大文件.我认为 xlExcel12 (带有宏的二进制文件，*.xslb)或 xlExcel8 (2003年之前的标准Excel文件)是更好的选择.

If you want to save the workbook with macros in Open XML format you can use: xlOpenXMLWorkbookMacroEnabled option, but it will crate a large file. In my opinion either xlExcel12 (binary file with macros, *.xslb) or xlExcel8 (standard Excel file till version 2003) are better options.

这篇关于Excel宏文件大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！