Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visio not releasing Excel

Status
Not open for further replies.

rolltide

IS-IT--Management
May 30, 2003
2
US
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
 
Don't forget Excelapp.Quit
Regards
BrianB
** Let us know if you get something that works !
================================
 
Thanks for the tip..Had it in the code. But it must have been Windows 98..Excel was still in taskman after the programm ran.. Moved to my XP machine and everything works fine,
Thx again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top