Problem in Export to excel

HCL Domino Domino Forum
1

Hii try send document from view to excel by script i able to send data to excel but problem is i m not able align the the header of excel sheet mean Colum title should be center of cell, (form both end mean vertical and horizontal)…

if any body know please helap me…

Thanks

rupesh

2

Subject: Problem in Export to excel

Hi,

You can do it on this way:

xlsAppExcel.range("A1:AC1" ).Select

With xlsAppExcel.Selection 

	.HorizontalAlignment = xlCenter

	.VerticalAlignment = xlCenter

End With

where xlsAppExcel is excel object.

I hope this will help.

Igor

3

Subject: Problem in Export to excel

In general, whenever I want to do some manipulation in Excel or Word I record a macro with the functions I need. And then I copy the result over to Lotusscript.

You might have noticed that the structure and commands used in the recorded macro look almost identical to those used in the OLE objects for the related application (see in the Designer the reference of OLE classes).

The only thing to change is when in the recorded macro definitions are used. You have to change those to their actual value. This can be seen by running the macro in debug mode and look at the value of those definitions.