Skip to main content

Posts

Showing posts with the label Export to excel

Top align excel cells in vbscript or lotusscript

I have searched many posts to top align excel cells while doing export to excel with lotus script, finally I got this working code: Const xlTop=-4160 Set xlApp = CreateObject("Excel.Application") Set xlsheet = xlApp.Workbooks(1).Worksheets(1) xlsheet.Cells.Select Set xlSelection=xlApp.Selection xlSelection.VerticalAlignment = xlTop