For reasons I won't go into here I am using VC to automate Excel. I have not had any problems except for two things. First I cannot create new worksheets using the Add method. For VC the worksheets Add method requires four arguments, after, before, count, and type. When I do this I get an error message of: "create new sheet class failed". What type of variant types are the arguments suppose to be (short, long, etc). What is the type value (-4167) ????


Also how does one use the SetFreezePanes? I pass TRUE but nothing happens.

Thanks

Jim Bassett