Click to See Complete Forum and Search --> : OLE32 error


cecooper
April 7th, 2001, 10:56 AM
I am using vb to build and display a spreadsheet in excel using "create object"
for the excel application. I recently added a module to the app that contains a dynamic macro and now when I try to close VB, excel generates an OLE32 error.
I am setting the objects to "nothing" on close. I was wondering if I am missing an ole initialize command or something. I was able to close with no error until I added the module with a macro. Thanks