H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #1 我要用DELPHI设置一个已经存在的EXCEL文件的数据筛选为自动筛选,如何用代码实现?
H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #3 starbzj:如何在delphi里面实现呢?可不可以说具体一点?
H hbezwwl Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #4 在DELPHI中使用EXCEL的VBA 来设置,具体的要参考vba for excel
H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #5 hbezwwl:可否email个例子给我?Hebaisong@taihsing.com.cn
H hbezwwl Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #7 其实只要参考一下vba for excel写起来不难的,帮助都是中文.示例也多.
H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #8 ExcelApp:=CreateOleObject('Excel.Application'); MyWorkBook:=CreateOleObject('Excel.Sheet'); MyWorkBook:=ExcelApp.Workbooks.Open(SaveDialog1.FileName+'.XLS'); 执行这一句出错: MyWorkBook.WorkSheets[1].Cells[0,1].autoFiler:=True; 请问该怎么做?
ExcelApp:=CreateOleObject('Excel.Application'); MyWorkBook:=CreateOleObject('Excel.Sheet'); MyWorkBook:=ExcelApp.Workbooks.Open(SaveDialog1.FileName+'.XLS'); 执行这一句出错: MyWorkBook.WorkSheets[1].Cells[0,1].autoFiler:=True; 请问该怎么做?
H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #9 hbezwwl:老兄,我还真的没董呢!可否明示,谢谢!
H HeBaisong Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #10 hbezwwl:vba for excel我不清楚,以前还没有听过呢!可否指教一二?谢谢!在那儿有例子 一看!?
O onlyonekgx Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-16 #11 Ranage:=Sheet.Rows['1:7']; Ranage.AutoFilter; Ranage.AutoFilter(1,'26');