Nalij_isPower
New Member
- Joined
- Aug 16, 2007
- Messages
- 3
Excel + COM+
1. I am trying to code the Autofilter process in my script using COM+.
I can open autofilter, how do you select? The VB code does not work for COM+.
2. Is there a site with examples for scripting Excel with COM+?
3. Is there a site that show the difference in the commands needed to code Excel COM+ vs Excel VB?
Below is the code I am trying to use.
Dim ExcelApp,ExcelBook,ExcelSheet as variant
Dim Field, Criteria1 as string
Dim BULDNME as string
BULDNME="D"
.
.
.
ExcelBook.WorkSheets("Sheet2").Range("a:a").AutoFilter ' Autofilter on
ExcelBook.WorkSheets("Sheet2").Range("a:a").AutoFilter Field:=1,Criteria1:=BULDNME
Thanks for your time.
D.
1. I am trying to code the Autofilter process in my script using COM+.
I can open autofilter, how do you select? The VB code does not work for COM+.
2. Is there a site with examples for scripting Excel with COM+?
3. Is there a site that show the difference in the commands needed to code Excel COM+ vs Excel VB?
Below is the code I am trying to use.
Dim ExcelApp,ExcelBook,ExcelSheet as variant
Dim Field, Criteria1 as string
Dim BULDNME as string
BULDNME="D"
.
.
.
ExcelBook.WorkSheets("Sheet2").Range("a:a").AutoFilter ' Autofilter on
ExcelBook.WorkSheets("Sheet2").Range("a:a").AutoFilter Field:=1,Criteria1:=BULDNME
Thanks for your time.
D.