Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

Sikkim Darjeeling Tour

Visited Sikkim and Darjeeling on 13-Jun-2015 to 20-Jun-2015 with my wife. Here is trip information which you might find helpful to plan your North East trip  Day 1 -  1) Mumbai to Bagdogra flight ( Rs 8000 per person) 2) Bagdogra to Kalimpong (Prepaid cab Rs 1400, 3 hours) 3) Kalimpong siteseeing (takes 2 - 3 hours)     1. Cactus Nurseries     2. Durbin Dara Monastery     3. Mangal Dham     4. Deolo Hill 4) Kalimpong to Gangtok (2.5 hours)     Full day taxi 4200     Overnight stay at Gangtok Day 2 - 1) Gangtok 10 point siteseeing (local taxi Rs 1600. 5 hours)     1. Bakhtang waterfall     2. Gunjung Monetrary     3. Tashi view point     4. Lasa waterfall     5. Plant Consertaion     6. Ganesh Tok     7. Flower show (must visit)     8. Ropeway     9. Institute of Tibetology (Closed on Sunday...
25 comments
Read more

eFiling of IT Returns AY 2018-19

e-Filing of income tax is quite simplified process. This blog will help you to file own IT returns online with ITR-1 form for Assessment Year 2018-19 (Financial Year 2017-18). Last Date: 31st August 2018. This year penalty of Rs 1000 to Rs 5000 has been introduced for filing returns after the due date but before 31st Dec 2018 and Rs 10000 post 31st Dec 2018. ITR-1 form is applicable if you have income from following sources: Salary House rent / loan Interest on saving bank account / FD Agriculture income less than Rs 5000 Shares dividend + Other non taxable income Prerequisites for e-filing Form 16 Form 26AS (refer Step 4 below) Interest from saving bank account / FD Any investment that is not declared with company or not reflected in Form 16 Follow below steps to e-file your IT Returns  (click on pictures to enlarge) Step 1  – Get Form 16 from your employer Step 2  – Register yourself at site  https://www.incometaxindiaefiling.g...
10 comments
Read more