Hello to everybody,

I need the method to combine cells working with the excel activex. Any Idea?

Best Regards
Ernesto Avedillo

Ernesto,

oExcel:Workbooks:Open("BlahBlahBlah.Xls")
oWorkSheet             :=oExcel:Workbooks:Item(1):Sheets:Item(1)
oWorkSheet:Select()

oRange                 :=oExcel:Range("A3:G3")
oRange:Select()

oRange:=oExcel:Selection()
oRange:Merge()

HTH,
Frans Vermeulen

> Hello to everybody,
> 
> I need the method to combine cells working with the excel activex. Any Idea?
> 
> Best Regards
> Ernesto Avedillo 
> 
>

Thank you very much.
I was crazy looking for this method.
Ernesto

"Frans Vermeulen" <fransv@sluyter-routing.nl> escribi en el mensaje 
news:20080611155953.87241740.fransv@sluyter-routing.nl...
> Ernesto,
>
> oExcel:Workbooks:Open("BlahBlahBlah.Xls")
> oWorkSheet             :=oExcel:Workbooks:Item(1):Sheets:Item(1)
> oWorkSheet:Select()
>
> oRange                 :=oExcel:Range("A3:G3")
> oRange:Select()
>
> oRange:=oExcel:Selection()
> oRange:Merge()
>
> HTH,
> Frans Vermeulen
>
>> Hello to everybody,
>>
>> I need the method to combine cells working with the excel activex. Any 
>> Idea?
>>
>> Best Regards
>> Ernesto Avedillo
>>
>>

Ernesto Avedillo wrote:
> Thank you very much.
> I was crazy looking for this method.
> Ernesto

The easiest way to work out how to do things in Excel is to record a 
macro and look at the resulting VB code.  It's normally easy ro 
translate to xBase.

Paul