I'm ungrouping 215 shapes in Visio then writing the shape text out to Excel. The 1st time visio runs everything works fine. If I rerun the macro excel will open but will not display the workbook. If I reset the macro before the code ends I can run every time. I'm setting all the obects to NOTHING when the code ends. The workbook is phantom and only way to access it is to reboot. Using Visio 2000, Excel 97 and windows 98.
Public ExcelApp as Object 'Tried Excel.application, New Excelapplication. both give same results.
set ExcelApp = CreateObject("Excel.Application"
Set Excelapp = Nothing
Thanks
Public ExcelApp as Object 'Tried Excel.application, New Excelapplication. both give same results.
set ExcelApp = CreateObject("Excel.Application"
Set Excelapp = Nothing
Thanks