working with excel and vb 6.9

[xavierrangel]

does anyone know how to create an excel spreadsheet by clicking a button in visual basic 6.0?

[kadghar]

Hi, you can try this out:

Dim sheet As Object
Set sheet = CreateObject("excel.application")
sheet.Visible = True

Hope it helps

[xavierrangel]

Hi, you can try this out:

Dim sheet As Object
Set sheet = CreateObject("excel.application")
sheet.Visible = True

Hope it helps

hey! it just opens an excel something in the toolbar for less than a second and then disapear. thanks for helping

[eklavyavats]

hey! it just opens an excel something in the toolbar for less than a second and then disapear. thanks for helping

You can also work out with the macro if you can...