[RESOLVED] calll Excel from VB

[mutley]

Hi

I Build a Excel File using VB as below

'--------------------'
    '  Instancia Excel   '
    '--------------------'
    Set objXl = CreateObject("Excel.Application"): objXl.Visible = False
    '--------------------'
    ' Abre Novo Arquivo  '
    '--------------------'
    Set objBook = objXl.Workbooks.Open(sNovo_Arquivo, , , , "")
    Set objSheet = objBook.ActiveSheet

    objSheet.Cells(4, 1).CopyFromRecordset rsEvento ', 65536

    '-------------------------
    ' Salva planilha
    '------------------------
    Set objSheet = Nothing
    objBook.Close SaveChanges:=True
    Set objBook = Nothing
    objXl.Quit
    Set objXl = Nothing

I tried to open excel using shell

   shell sNovo_Arquivo

Is there other way to open Excel without to let excel object opened inside VB ?

[si_the_geek]

Shell only runs applications.

To open a file, use ShellExecute. For more information, see the article How do I open a file/web-page in its default application? from our Classic VB FAQs (in the FAQ forum)

[mutley]

thank you