asked on

Excel Autofilter & Color formatting thru vbscript

Hi,

Would like to set autofilter & color formatting based thru vbscript.

for example: would like to set
1. Autofilter from column A to I
2. A - B color in yellow, C - D green in color etc

Please advise how can I achieve this thru vbscript

Thanks in advance

Wayne Taylor (webtubbs)

VBA or VB Script?

VBA (Visual Basic for Applications) is the code contained within MS Office applications.
VB Script is usually run from .vbs files, or ASP.

Wayne

grind67

ASKER

Hi Wayne, it is vb script (not Visual basic for applicatons)

If achieving thru VB script is NOT too hard then I would request this way
OR
Please advise alternate way?
Basically, I create excel file thru an automated process (with header & data) and place it under a folder. If there is some mechanism (Windows/Microsoft office 2003 out of the box softwrae/Util) to apply this color format & autofilter...would try this way as well

Unfortunetly, I cannot use VB 6

thanks

grind67

ASKER

Fully automated solutions...right from the excel file creation to autofilter & color formatting

Have done the Excel creation & sending email but only outstanding thing is autofilter & color formatting...I think it is bit tricky

ASKER CERTIFIED SOLUTION

Wayne Taylor (webtubbs)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

grind67

ASKER

HI Wayne, that was excellent. Solved my problem...thanks a lot

Excel Autofilter &amp; Color formatting thru vbscript

Excel Autofilter & Color formatting thru vbscript