wrapping an excel vba app in vb?

[deetee2k]

Hi,

I have created an excel vba app which runs ok and all the users are happy. However, now I want to convert it into a VB app so it can do other wonderful things. Does anyone know how to do this with a minimum of fuss? The target audience will have office installed.

Thanks,

D. "I want to play..."
(Guess the X-Files episode!)

 

[StewartJ]

Dim objExcel as Object ' Use late binding to be independent of Excel version

objExcel = CreateObject(Excel.Application)

With objExcel

...{Your existing VBA code} ...

.Quit

End With

Set objExcel = Nothing