求救：如果操作OLE控件(Excel工作表)，急!急!急!急!急!急!急!急!急!急!急!

[bunnysky]

各位大虾：我在窗口中插入了OLE控件(Microsoft Excel工作表)，想要操作该控件的属性、事件、函数，但苦于不知道该控件有哪些属性、事件、函数。肯请各位大虾帮个忙指点一、二，如果你有关于这方面的文档请不吝发一份给我不胜感谢!!

[bunnysky]

在线等待：QQ 4849701，急用!!谢谢!!

[iagcel]

属性：
string _CodeName
OleObject Application
OleObject AutoFilter
boolean AutoFilterMode
OleObject Cells
OleObject CircularReference
string CodeName
OleObject Columns
OleObject Comments
int ConsolidationFunction
any ConsolidationOptions
any ConsolidationSources
int Creator
boolean DisplayPageBreaks
boolean DisplayRightToLeft
boolean EnableAutoFilter
boolean EnableCalculation
boolean EnableOutlining
boolean EnablePivotTable
int EnableSelection
boolean FilterMode
OleObject HPageBreaks
OleObject Hyperlinks
long Index
string Name
OleObject Names
OleObject Next
OleObject Outline
OleObject PageSetup
OleObject Parent
OleObject Previous
boolean ProtectContents
boolean ProtectDrawingObjects
boolean ProtectionMode
boolean ProtectScenarios
OleObject QueryTables
OleObject Rows
OleObject Scripts
string ScrollArea
OleObject Shapes
double StandardHeight
double StandardWidth
boolean TransitionExpEval
boolean TransitionFormEntry
int Type
OleObject UsedRange
int Visible
OleObject VPageBreaks

[iagcel]

事件：
Activate()
unsigned long AddRef()
BeforeDoubleClick(OleObject Target, boolean Cancel)
BeforeRightClick(OleObject Target, boolean Cancel)
Calculate()
Change(OleObject Target)
Deactivate()
FollowHyperlink(OleObject Target)
GetIDsOfNames(OleObject riid, string rgszNames, unsigned int cNames, unsigned long lcid, REF long rgdispid)
函数：
_CodeName(string _CodeName)
any _Evaluate(any Name)
Activate()
AutoFilterMode(boolean AutoFilterMode)
Calculate()
OleObject ChartObjects(any Index)
CheckSpelling(any CustomDictionary, any IgnoreUppercase, any AlwaysSuggest, any SpellLang)
CircleInvalid()
ClearArrows()
ClearCircles()
Copy(any Before, any After)
Delete()
DisplayPageBreaks(boolean DisplayPageBreaks)
DisplayRightToLeft(boolean DisplayRightToLeft)
EnableAutoFilter(boolean EnableAutoFilter)
EnableCalculation(boolean EnableCalculation)
EnableOutlining(boolean EnableOutlining)
EnablePivotTable(boolean EnablePivotTable)
EnableSelection(int EnableSelection)
any Evaluate(any Name)
Move(any Before, any After)
Name(string Name)
OleObject OLEObjects(any Index)
Paste(any Destination, any Link)
PasteSpecial(any Format, any Link, any DisplayAsIcon, any IconFileName, any IconIndex, any IconLabel)
OleObject PivotTables(any Index)
OleObject PivotTableWizard(any SourceType, any SourceData, any TableDestination, any TableName, any RowGrand, any ColumnGrand, any SaveData, any HasAutoFormat, any AutoPage, any Reserved, any BackgroundQuery, any OptimizeCache, any PageFieldOrder, any PageFieldWrapCount, any ReadData, any Connection)
PrintOut(any From, any To, any Copies, any Preview, any ActivePrinter, any PrintToFile, any Collate, any PrToFileName)
PrintPreview(any EnableChanges)
Protect(any Password, any DrawingObjects, any Contents, any Scenarios, any UserInterfaceOnly)
OleObject Range(any Cell1, any Cell2)
ResetAllPageBreaks()
SaveAs(string Filename, any FileFormat, any Password, any WriteResPassword, any ReadOnlyRecommended, any CreateBackup, any AddToMru, any TextCodepage, any TextVisualLayout)
OleObject Scenarios(any Index)
ScrollArea(string ScrollArea)
Select(any Replace)
SetBackgroundPicture(string Filename)
ShowAllData()
ShowDataForm()
StandardWidth(double StandardWidth)
TransitionExpEval(boolean TransitionExpEval)
TransitionFormEntry(boolean TransitionFormEntry)
Unprotect(any Password)
Visible(int Visible)

[888888888888]

同意楼上

[ice2water]

在添加ole时先选中，再点下面的browse，即可查看事件与属性

[th820901]

哈哈 UP！

[norzss]

请问在pb中怎样调用excel把一个文件另存为一个text文件，谢谢！
（saveas函数的用法？）