I am trying to use AutoFormat in VBScript through SQL Server in a DTS
package. Most everything is going great but I can't figure out the
syntax for this line:
oSSBExcel.Range("A65536").End(xlup).AutoFormat Format:=11
This is supposed to grab the last used row and apply an autoformat. It
works great when run in Excel, but I think it chokes on Format:=11.
Is there a way to say this in VBScript?
Thanks much.
Weezy
--
Weezy1957
------------------------------------------------------------------------
Weezy1957's Profile:
http://www.excelforum.com/member.php...o&userid=24498
View this thread:
http://www.excelforum.com/showthread...hreadid=380924