1、FameView 組態(tài)軟件技術(shù)附件.腳本如何以只讀方式打開 Excel 文件啟動ExcelSet ExcelObj = CreateObject(Excel.Application) 打開某Excel文件ExcelFile = C:Temp20100309.xls ExcelObj.Workbooks.Open ExcelFile,1 True 顯示Excel窗口 ExcelObj.Visible = True 銷毀Excel對象Set ExcelObj=Nothing附打開Excel文件的函數(shù)說明:expression.Open(FileName, UpdateLinks, ReadOnly

2、, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad).1.NameRequired/O ptionalData TypeDescriptionFileNameOptionalVariantString. The file name of the workbook to be opened.UpdateLinksOptionalVariantSpecifies the

3、 way links in the file are updated. If this argument is omitted, the user is prompted to specify how links will be updated. For more information on the values used by this parameter, see the Remarks section. If Microsoft Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks argu

4、ment is 2, Microsoft Excel generates charts from the graphs attached to the file. If theFameView 組態(tài)軟件技術(shù)附件.腳本argument is 0, no charts are created.ReadOnlyOptionalVariantTrue to open the workbook in read-only mode.FormatOptionalVariantIf Microsoft Excel is opening a text file, this argument specifies

5、the delimiter character. If this argument is omitted, the current delimiter is used. For more information on the values used by this parameter, see the Remarks section.PasswordOptionalVariantA string that contains the password required to open a protected workbook. If this argument is omitted and th

6、e workbook requires a password, the user is prompted for the password.WriteResPasswordOptionalVariantA string that contains the password required to write to a write-reserved workbook. If this argument is omitted and the workbook requires a password, the user will be prompted for the password.Ignore

7、ReadOnlyRecommendedOptionalVariantTrue to have Microsoft Excel not display the read-only recommended message (if the workbook was saved with the Read-Only Recommended option).OriginOptionalVariantIf the file is a text file, this argument indicates where it originated (so that code pages and Carriage

8、 Return/Line Feed (CR/LF) can be mapped correctly). Can be one of the following XlPlatform constants: xlMacintosh, xlWindows, or xlMSDOS. If this argument is omitted, the current operating system is used.DelimiterOptionalVariantIf the file is a text file and the Format argument is 6, this argument i

9、s a string that specifies the character.2.FameView 組態(tài)軟件技術(shù)附件.腳本to be used as the delimiter. For example, use Chr(9) for tabs, use , for commas, use ; for semicolons, or use a custom character. Only the first character of the string is used.EditableOptionalVariantIf the file is a Microsoft Excel 4.0 a

10、dd-in, this argument is True to open the add-in so that its a visible window. If this argument is False or omitted, the add-in is opened as hidden, and it cannot be unhidden. This option doesnt apply to add-ins created in Microsoft Excel 5.0 or later. If the file is an Excel template, True to open t

11、he specified template for editing. False to open a new workbook based on the specified template. The default value is False.NotifyOptionalVariantIf the file cannot be opened in read/write mode, this argument is True to add the file to the file notification list. Microsoft Excel will open the file as

12、 read-only, poll the file notification list, and then notify the user when the file becomes available. If this argument is False or omitted, no notification is requested, and any attempts to open an unavailable file will fail.ConverterOptionalVariantThe index of the first file converter to try when

13、opening the file. The specified file converter is tried first; if this converter doesnt recognize the file, all other converters are tried. The converter index consists of the row numbers of the converters returned by the FileConverters property.AddToMruOptionalVariantTrue to add this workbook to th

14、e list of recently used files. The default value is False.LocalOptionalVariantTrue saves files against the language of Microsoft Excel (including control panel settings). False (default) saves files against the language of Visual Basic for Applications (VBA) (which is typically US English.3.FameView 組態(tài)軟件技術(shù)附件.腳本unless the VBA project where Workbooks.Open is run from is an old internationalized XL5/95 VBA project).CorruptLoadOpt