Excel and VB.net 2

[DotNetBlocks]

Hello,

Is there a way to create an excel file on the fly, with macros dynamicly created based on criteria?

Thanks,

Babloome

 

[DotNetBlocks]

I can use 2003 or 2005.

Babloome

 

[Sorwen]

Create a file yes.

Public Sub CreateExcel()
        Dim oExcel As Object
        Dim oBook As Object

        oExcel = CreateObject("Excel.Application")
        oBook = oExcel.Workbooks.Add

        'Macro code if possible

        oBook.SaveAs(WorkbookLocation & WorkbookName)
        oBook = Nothing
        oExcel.Quit()
        oExcel = Nothing
        GC.Collect()

About macros on the file I have no clue.

-I hate Microsoft!
-Forever and always forward.

 

[Sorwen]

For got to:

End Sub

at the end there.

-I hate Microsoft!
-Forever and always forward.

 

[DotNetBlocks]

How do you add the macro dynamicly?

 

[DotNetBlocks]

Sorwen,

Thanks for the help.

 

[MacLeod72]

The following link may be of use:

http://support.microsoft.com/kb/303871

--Rob

 

[DotNetBlocks]

Perfect, Thanks