Results 1 to 4 of 4

Thread: Insert new column Excel 2002 (xp ) x Excel 2000

Threaded View

  1. #1

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Insert new column Excel 2002 (xp ) x Excel 2000

    Hi

    I did the source code of my application with VB and Excel is 2002 (xp), But when I put my application in server
    The application no show

    Environment of my machine is Excel 2002 and environment of Server (CTRIX) is Excel 2000

    figure01 no work
    figure02 work fine

    My code

    Code:
       'Insere Coluna
        .Columns("AF:AF").Select
        .Selection.Insert Shift:=xlToRight
           
         'Cabeçalho
       .Range("AF3").Select
       .ActiveCell.FormulaR1C1 = "Data de Expedição"
       'Acrescenta Dados do Array na coluna
       .Range("AF4:AF" & CStr(3 + UBound(Dt_Expedicao))).Value = Application.WorksheetFunction.Transpose(Dt_Expedicao)
       .Range("AF4:AF" & CStr(3 + UBound(Dt_Expedicao))).HorizontalAlignment = xlCenter
       .Range("E1").Select
    Attached Images Attached Images   

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width