| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBScript MS Excel Problem
Hi All,
Just wondering if anyone knows the correct way to pass arguments to the autofilter method when using VBScript to automate MS Excel. Below, please find a code snippet that keeps failing. Code:
Set o_excel = CreateObject("excel.application")
o_excel.visible = True
o_excel.workbooks.open v_file + ".csv"
Set o_wrksht = o_excel.activesheet
o_wrksht.cells(2, 1).autofilter
o_wrksht.cells(2, 10).autofilter 10, "="
Does anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run VBScript from Excel | Excel Discussion (Misc queries) | |||
| Excel sorting in VBScript | Excel Programming | |||
| Excel & VBScript | Excel Programming | |||
| Using excel through vbscript | Excel Programming | |||
| how to kill excel using a vbscript | Excel Programming | |||
Threaded Mode
